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.