Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.4

Bug #17334 performance problem on 0.9.2
Submitted: 2010-04-22 13:15 UTC
From: piviul Assigned:
Status: Feedback Package: Spreadsheet_Excel_Writer (version 0.9.2)
PHP Version: 5.2.6 OS: Debian lenny
Roadmaps: (Not assigned)    
Subscription  


 [2010-04-22 13:15 UTC] piviul (Paolo Sala)
Description: ------------ Hi, I've upgraded Spreadsheet_Excel_Writer from 0.9.1 to 0.9.2. The time to fill a spreadsheet is very huge now. In the 0.9.1 the time to fill the rows was constant; now with the 0.9.2 the time to fill a row, augment continuously. For example these are the times spent to fill every 1000 rows in 0.9.2: 22-4-2010 09:13:23: time to fill from row 0001 to 2000: 00:00:17 22-4-2010 09:14:20: time to fill from row 2001 to 3000: 00:00:57 22-4-2010 09:15:51: time to fill from row 3001 to 4000: 00:01:31 22-4-2010 09:17:57: time to fill from row 4001 to 5000: 00:02:06 22-4-2010 09:20:40: time to fill from row 5001 to 6000: 00:02:43 These are the same logs with the 0.9.1: 22-4-2010 09:26:14: time to fill from row 0001 to 2000: 00:00:02 22-4-2010 09:26:16: time to fill from row 2001 to 3000: 00:00:02 22-4-2010 09:26:18: time to fill from row 3001 to 4000: 00:00:02 22-4-2010 09:26:20: time to fill from row 4001 to 5000: 00:00:02 22-4-2010 09:26:23: time to fill from row 5001 to 6000: 00:00:03 I have obtained these results using a script that can be tested only in my network (the data are retrieved from a db) on a very old pc (PIII 800) but I'm sure you can obtain the same relative results from a custom script you can construct. If you want I can write a script for you to test. Thank you very much for the time you spent for improve this tool. Have a nice day Piviul

Comments

 [2012-01-26 08:21 UTC] doconnor (Daniel O'Connor)
-Status: Open +Status: Feedback
Thank you for taking the time to report a problem with the package. This problem may have been already fixed by a previous change that is in the SVN of the package. Please checking out the SVN repository of this package and upgrade svn checkout svn.php.net/repository/pear/packages/Spreadsheet_Excel_Writer/trunk pear upgrade package2.xml or pear upgrade package.xml If you are able to reproduce the bug with the latest SVN, please change the status back to "Open". Again, thank you for your continued support of PEAR.