Re: Which is Optimal

[vikramjit singh]

nopes, no good, only add more burden since you shall have to parse them. What we used to do, is fetch 100 records at a time (if the traffic is slow you can even fetch more), put it in a session, and then iterate through the records, when he reaches 100, for seeing the next 10 then there is a database query...   -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]On Behalf Of K R Viju Sent: Friday, June 13, 2003 2:50 PM To: [EMAIL PROTECTED] Subject: Which is Optimal This is my scene.   I have around 1, 000, 000 products in database. In my front end, user can select products by clicking a button. once user clicks the button i have to show him all the products from the database, as a popup. Now to show all 1, 000, 000 products, system hangs, responds after 5 minutes.   How can i show all products without much overhead. will XML do any good.   Vj