tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Praveen Potineni" <>
Subject Re: Server crashes...
Date Fri, 09 Nov 2001 13:45:48 GMT
Hi all,
Thanks for the suggestion you have given on this topic. Though my intention
is not to make the user surf thru all the million records, but i was trying
to test such a big load. Our application is in the initial stages of
development and i was trying to see if tomcat can handle such a big load.
I'm using Sybase ASA 6.0 and jConnect sybase driver for JDBC.
Yeah ..I would definately narrow my query to retrieve few records to
display. I was trying to do what my boss had asked me to do.

Thanks again.

----- Original Message -----
From: "Richard Troy" <>
To: "Tomcat Users List" <>
Sent: Thursday, November 08, 2001 3:53 PM
Subject: Re: Server crashes...

> Praveen,
> You have a query returning a million rows and you want to make the data
> access quick. Hmmm... I have to question your strategy. HTML and the world
> wide web are oriented toward serving humans directly and while I'm not
> saying it's impossible, I find it hard to believe that there's a
> legitimate reason for a human being to try and look at a million result
> rows on a web page. If you are serving a human being, reduce the result
> set to something reasonable. You didn't say your query uses SQL but
> presuming that it is, use the WHERE clause. A reasonable return value for
> a real human being is probably less than one hundred, or thereabouts. If
> your applicaiton is not serving a human being, then use a direct, non-html
> based application approach - traditional client-server style.
> Hope this helps,
> RT
> Richard Troy, Chief Scientist
> Science Tools Corporation
>, 510-567-9957,
> On Thu, 8 Nov 2001, Praveen Potineni wrote:

> > Hi all,
> > I have a query which gets 1 million records. When i try to query from a
bean and access it from JSP(i'm using Tomcat 4.0 on win 2000), the
application takes forever and finally crashes on me. It says running out of
virtual memory.
> > I have a question:
> > What is the physical location of the resultset. When i do a query where
is the result set coming and storing all the values.What is the physical
location of the data that is being retrieved.
> >
> > How can i make the data access quick.
> >
> > Thanks
> > Praveen

To unsubscribe:   <>
For additional commands: <>
Troubles with the list: <>

View raw message