JSP - Database Query and Vector
Posted on 2002-04-23
I am running a database query which returns 7000 records with 4 fields each.
The flow is as follows:
Click on link to Page 2
Accesses bean which runs query and stores records in vector.
Vector is passed back to Page 2.
First 20 element of vector is displayed.
The scenario is a back/forward through records and display 20 results at a time.
My problem is that getting the results into the vector takes very long (13-15 secs).
So the initial 20 results seem to take forever to load, thereafter everything is fast because it only reads the vector.
Is there a faster way to do this ? As far as I know, a vector is the quickest.
Any help to get the execution time down will be appreciated.