I'm not sure what the overhead would be like but rather than saving the data in a session variable what would the performance hit be if the returned search results were saved in a temporary table in the database? Save it in a temporary table with an autoincrement column and name the table with a naming convention that would uniquely identify it against a user session variable such as their username. Then you just query the table each time giving a range for the autoincrement column.
Any thoughts on this? I just kind of picked it up right now. This would take a lot of the stress off of the container and any overhead from maintaining large session variables. Especially if you have a robust db system. You may have to implement your own garbage collection to remove the temporary tables if it hasn't been accessed in more than say 5 minutes. ~Matt Quoting Jo�o Robertson Kramer Santana <[EMAIL PROTECTED]>: > Until now I havent found a good solution for this problem. Today > I > save the key of the last record showed in the user form . When the > user > submits the form I : > 1) open the cursor again (I save the query parameters in the form too) > 2) if he pressed the "Next" button then move the cursor to the saved key > and > show "n" more records > 3) if he pressed the "Back" button then move the cursor to "n" records > before the saved key > 4) save the key of last record showed in a form variable > 5) save the query fields in forms variables > 6) response > > I cant make any cache because i dont know how big would be the > query > result. I would like to know others solutions for this problem, because > the > one I use gives me a lot of work! > > bye > > jk > > ___________________________________________________________________________ > 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 > ___________________________________________________________________________ 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
