struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Owen" <>
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" <>
To: "Struts Users Mailing List" <>
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
> 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:   <>
For additional commands, e-mail: <>

View raw message