Hi All I am designing an application for a website and caught up with some design questions. In my application I have a lot of static data, stored in a database, needs to be provided to user based on the query . As the data volume is high I don't want to access the database for each user request (response time would be too high, low performance) put by the users. As an alternative I am thinking of writing "HTML File Generator"(Java Servlet) application which access the database and create HTML files. Also It will store the path to these HTML files in a table "HTML Tag lists" along with unique KEYs which can be easily generated out of user Queries . This is a one time event which will be executed in the backend by administrator. All the user queries would be "interpreted" by a "Search Engine" (Java Servlet)applciation , transforming the QUERY into a unique key and searching for the corresponding file path in "HTML Tag lists" table.Thus HTML file will be displayed on the screen. Can anybody help me on the following doubts : 1. Are there any disadvantages with this approach? 2. I want to seperate the conent & design (I worked on Webmacro and love to use that again here) in my "HTML Generator" application and generate the HTML files. Is it possible to write the output of "WMServlet" output to a file instead of the browser? 3.any other approaches for this kind of problems? Ur help is greatly appreciated.... TIA, -pradeep ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
