Re: Which is Optimal

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