I have created a command (CVTXLS) to convert a file into an EXCEL spreadsheet using the HSSF/POI classes from Jakarta project. (Thanks to Scott Klement for his documentation)
I am using this command to convert a 466,000 record file into a spreadsheet. It has 113 columns of mostly numeric data. The code already is able to break every 65k records and start a new tab.
The problem is after processing over 35k records quite quickly, it is now working very slowly and I was wondering why? Is this a memory allocation problem? Can I speed thinks up by saving the file every now and then?
Can anyone tell me why it suddenly when from 30k records in the first hour to only a few hundred records in the next hour? But more importantly, is there anything I can do short of multiple files, to help the program process the file faster?
Thanks,
Marvin
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
