To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101942
------- Additional comments from [email protected] Mon Feb 15 14:59:51 +0000 2010 ------- Same problem here! We do data gathering from large xls-files (1.5 to 3 MB) on a Linux server using OOo calc (many thousands xls files) and feed the extracted csv-data into a database. But now may be getting forced to change to a Windows environment ;-( due to very poor performance. E.g.: xls sample file (2.5 MB, no charts - only formula and text, 3x ~30k jpgs) Some Benchmarks (opening the xls until content is visible/usable; no macros executed): OOo 2.4, Ubuntu 8.04 LTS (Xenon multicore cpu, 8MB RAM): 10+ MINUTES OOo 3.1, Ubuntu 9.10 Desktop (AMD multicore, 4GB RAM): 8 to 15 minutes (time varies with the same testfile!?) OOo 3.2, Ubuntu 9.10 NBR (Asus Eee PC 1005H, 2GB RAM): ~3 minutes (=> OOo 3.2 is ~3x faster here than 3.1, even on an very small computer) M$ Excel (Office 10/XP), Win XP, (Laptop 1.2Ghz cpu, 1GB RAM): 3-5 seconds M$ Excel 2004, OS-X, (MacBook Pro 2.5Ghz, 4GB): 10 seconds Performance gap OOo Calc : Excel (Minutes vs. Seconds!) =~ 200 : 1 Performance is not dependend on auto_open macros or external file references. Performance degrades tremendiously if files getting larger. I am not able to upload a sample file here (customer property), but will be glad to send one as personal email if needed. BTW: Out of curiosity i've done a "strace -t -f scalc sample.xls" and have seen a lot of "Resource temporarily unavailable"-messages, but can't conclude if this has to do with the performance issues regarding opening large xls-files. --------------------------------------------------------------------- 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]
