Yes i understand that i have to bring only 100 records to client , but
when the client wants next 100 records from where will I get them on the
server(i can find them only if i saved them somewhere on my server ), only
way is to requery the database and that is even more expensive in my case
becuse iam using 3 tier system, so everytime goin back to database server is
very expensive.
regards
karan
>From: Selvamani Jayakumar <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: interesting one, 200 concurent users, large resultstes
>Date: Thu, 3 Aug 2000 01:32:34 IST
>
>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
________________________________________________________________________
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
