Hi All, I am involved in the development of servlet based database search program. Currently this program is done using CGI program in C. In this program, Contents of Oracle table is dumped to the Shared Memory segment of UNIX and database search is carried out in the memory to speed up the search process. I am not sure if I implement this program using Servlet, does it really improve my database search speed. Because the data size is more than One million records. I would like to get some idea regarding this. Any kind of algorithm available in java to do large database search. I dont want to create a database connection in each Client request. I thought of doing database connection and storing 1 million record in java object like (Vector or in ResultSet ) in init() of servlet and make this object available to multiple clients. I dont know whether I am thinking in right direction. Any guidance in this regard is very much appreciated. Please share your experience thanks in advance jaison ___________________________________________________________________________ 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
