This has nothing todo with Tomcat, but I propose you make a standalone
application doing this and then using a profiler on it.
Ronald.
On Thu Jul 20 15:17:34 CEST 2006 Tomcat Users List <users@tomcat.apache.org>
wrote:
Hi,
I am building xls with jakarta POI by fetching the records from database.
There are 30K records fetched from DB.
Process takes 40 min to complete.
Any best practises on using POI api to improve the performance.
I dont see issue with the query as
The query is very simple , it is just select from the table.
Explain plan on the query is good... no FTS ... all indexes used proporly
Thanks
---------------------------------
Find out what India is talking about on Yahoo! Answers India.
