To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46993 Issue #:|46993 Summary:|Calc is too slow to save an imported CSV file as a |SXC file Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|spreadsheet Reported by:|gnustavo
------- Additional comments from [EMAIL PROTECTED] Thu Apr 7 19:27:21 -0700 2005 ------- I'm having performance problems trying to import a CSV file into Calc and to export it into a SXC file. The original CSV file contains 50K CRLF separated lines. Each line contains 63 TAB separated columns. In the "Text Import" window I just deselect "comma" and select "tabulation" before importing it. I've tried this exercise in a Pentium IV, 1.5GHz box, with 512MB of RAM and running Debian Sarge Linux. I've used OOo 1.1.2 (ptBR) and 1.9.90 (enUS). I've truncated the CSV file in order to test it with 1000, 5000, 10000, and 32000 lines. The exercise was to open the CSV file and then to save it as a SXC file. The timings went like this: LINES 1.1.2(open) 1.1.2(save) 1.9.90(open) 1.9.90(save) 1000 3s 13s 3s 11s 5000 7s 1m20s 8s 50s 10000 16s 3m31s 16s 1m43s 32000 49s >10m (not tested) (not tested) The biggest problem is the time it takes to save the file as a SXC. Also note that the total time increases more then linearly with the number of lines in the file. With 32000 lines the OOo 1.1.2 simply took too much time for me to wait for it. Things are a little better with OOo 2.0 but not significantly so. The same file can be worked with very easily in Excel 2000 I was told (but couldn't confirm myself since I don't have a Windows box handy). I wondered if this could be due to the many numeric conversions with large numbers in the spreadsheet and tried once selecting "text" for the columns format. The opening time was cut in half but the saving time was cut in just 25% for the 10000 lines file. Also of interest is that after saving the spreadsheet as a SXC file it takes approximately the same time to open as it took to be saved, so that it is much worse to work with the SXC format than with the CSV format. I'm going to attach a CSV file with 1000 lines which I used to test. You can create larger files simply by catenating it several times. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
