G
gwinsor
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
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