hi
Normally all search engine works like that. You have to query
everytime to the Database Server even in 3 tier architecture.
One more alternate is using XML , where you can store all information
in XML file and generate the result. The XML file will have
mapping to the Table fields.
One disadvantage of using XML is only IE 5.0 browser supports, even
Netscape 6 doesnt support this.
>From: Karanjit Singh <[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: Wed, 2 Aug 2000 20:44:42 GMT
>
> 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
________________________________________________________________________
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
