Hi Leo. I've been using jxls for many years now and have noticed a huge decrease in performance over the years. I have a fairly large dataset that I've tried with 0.9.3, 0.9.7 and 1.0-rc2. The times are:
0.9.3: 28 minutes 0.9.7: 1 hour 1.0-rc2: 4 hours I've been profiling the code for a few days and was able to improve the 1.0-rc2 time by 2.5X (1 hour 45 minutes). However, I don't know what 0.9.3 was doing differently to be so fast. A lot of time is spent updating formulas after every transformation and with over 12,000 formulas and rising, this takes a long time. Any info and/or suggestions would be appreciated. Curtis PS - any work on new versions lately? ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user