Reliable approach to interact with database at webserver end?

Hi All,

I have following query regarding the dynamic webpages build in Interwoven environment -

At the Webserver end, webpages can interact with database in following two ways -1) By using TeamSite generated pages and using JSPs to interact with Database.
2) By using Livesite custom components which can call external Java class.

Which approach is more reliable for Database interaction to make the webpages dynamic.

Any pointer in this regard would be of great help.
Thanks in advance.

-Jangra

Find more posts tagged with

Comments

nipper

Either approach will be reliable. LiveSite offers a number of features (and a layer of complexity) that may be very appealing to the customer. If you are not using LiveSite then you need to decide if you want TS to generate DB records (with datadeploy), HTML pages (or fragments) or XML files that JSPs can use. That comes down to business decisions, size of pages, number of templates, etc.

There is no one size fits all approach. I am seeing more and more companies move away from the DB approach into an XML approach, for pages that have tens or hundreds of xml files to read. When you have thousands of records or files, then the DB approach is better.

Jangra

Thanks Nipper,
I agree with your point that DB approach is more preferable when the number of pages to be read are in thousands.

There is a need that end user interacts with the website and based on their comments, the pages are updated. What can be the more preferable approach suiting this requirement.