struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Owen" <johnlowen_b...@hotmail.com>
Subject Re: Struts and Large ResultSet
Date Thu, 22 Aug 2002 19:15:08 GMT
Yeah, my project required categorization of words in semantic contexts, so I
had to handle 100,000+ results. We used "lazy instantiation" to build keys
like you state and then get the more detailed information per user request.
It increased performance tremendously (and it made sense).

----- Original Message -----
From: "John Schroeder" <jschroeder@quovera.com>
To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
Sent: Thursday, August 22, 2002 1:47 PM
Subject: RE: Struts and Large ResultSet


> I agree with others who answered that 100,000+ records is terribly
unweildy
> for your average end-user to want to dig through....
>
> However, I have been involved in several projects that have had this
> requirement as well - anywhere from 1 - 2.5 million records returned (Hey,
> it's an imperfect world!)
>
> The solution that we have used was to have the initial "search" query only
> return keys (e.g. primary keys).  Just storing the keys in the session
> greatly reduced the memory footprint required to keep them.  Then for each
> "page" just pass the proper keys to the query to fetch detailed data.
>

--
To unsubscribe, e-mail:   <mailto:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message