Working with large number of search results in struts/jsp application
- From: gwinsor <glwinsor@xxxxxxxxx>
- Date: Thu, 6 Dec 2007 12:23:23 -0800 (PST)
I'm developing a struts/jsp web application that returns upwards of
30000 results obtained from a very complex schema and multiple queries
to the database.
We want the user to be able to paginate through the results, sort by
several fields, add/drop columns and download in several formats. We
don't expect heavy traffic but we do want it to be scalable.
Up to now, I have been storing the results in a session ArrayList
which can eat up a lot of memory. The queries take long to perform so
I do not want to repeat them with every request.
I would like to store in a single mysql temp table but I have read
that when the connection ends, the table is dropped. I understand that
creating a database Connection as a session variable is not a good
practice.
This is not a unique problem - I was hoping someone else has some
insight into the best way to proceed.
Thanks
.
- Prev by Date: Re: Math.cos() problems
- Next by Date: Re: Strange: compiles as Annotation but not as a method
- Previous by thread: JInternalFrame and accessing data between windows
- Next by thread: You know you're a Java freak when...
- Index(es):
Relevant Pages
|
