Go for small chunks. Query the database for only 50 rows and come back to the
client saying that there's more. Handle the traversing yourself with a custom
class.
Also, I'm not sure what times out in your scenario but if you're using IE and
it just quits waiting then you might want to get a patch from them. This is a
known issue. Search the archives for it.
dave.
"Nayak, Lingaraj (CAP)" wrote:
> I am trying to access a large database through the servlet and fetch the
> report to the browser but its damn slow and request is getting time out
>
> Any suggestions please
>
> Thanks
> Lingaraj
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
David Mossakowski [EMAIL PROTECTED]
Programmer 212.310.7275
Instinet Corporation
"I don't sit idly by, I'm planning a big surprise"
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
