Hi Karan
You dont need to store that many records in a cursor or array.
Some search engines uses the concept of Previous, Next (ie displaying
100 or more records at a time ). Whenever user clicks on Previous
or Next , you just need to bring 100 records to the client. Even the
performance wont get affected if there are more users.
Alternate is paging concept, where you display 100 (or more) records
per page , and the no. of pages will be based on maximum no. of
records.
You can try either of these options.
>From: Karanjit Singh <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: interesting one, 200 concurent users, large resultstes
>Date: Wed, 2 Aug 2000 19:42:25 GMT
>
>Dear members,
> Can anyone plz let me know that if i have to display 50,000 records at
>the client using JSP, where can i cash those records, if i keep all the
>records at the server in some array or scrollable cursor then my server
>will
>come to its knees when i get more then 200 concurnet hits(which iam
>expecting). If anyone has got any idea plz let me know.
> Do anyone knows what major search engines r doin, while displaying the
>results of searches which generate large resultsets. They r sending all the
>information to the client side, requering the database everytime the user
>hits next or they r not stateless and maintain the data at the
>servers(which
>i think whould really bring the server to knees)
> If anyone knows plz shed some light & help me.
> Thx in advance.
> Karan
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>http://java.sun.com/products/jsp/faq.html
>http://www.esperanto.org.nz/jsp/jspfaq.html
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
