tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Praveen Potineni" <potinen...@hotmail.com>
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.
Praveen

----- Original Message -----
From: "Richard Troy" <rtroy@ScienceTools.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Cc: "JSP_INTEREST" <JSP-INTEREST@JAVA.SUN.COM>
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
> rtroy@ScienceTools.com, 510-567-9957, http://ScienceTools.com/
>
> 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:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message