Apache OpenOffice (AOO) Bugzilla – Issue 27288
calc opens files slow - how to make it faster?
Last modified: 2004-04-01 11:10:19 UTC
I try to introduce OpenOffice in my office. My collegues complains, that the time for opening and saving calc files is too long. Has anybody a solution to make calc faster for opening files? i have a xls-file of 811KB, which i open in calc of OpenOffice 1.1.0. it takes 15 seconds for opening on a linux-system (suse 9.0 professional, kernel 2.4.21, kde 3.1.4, or gnome 2.2; 512 Mb RAM, and 2000Mhz Celeron processor). the file has 28 tables and 6 links to other calc files. when i don't update links to other files it takes a 15 seconds. when i update the links while opening it takes takes 1 minute 15 seconds. for comparison: the same file takes on the same machine with windows 2000 and MS excel 2000: 1 sec for opening without updating the links, 5 sec for with updating the links. i saved my file as a sxc-file. the size is now 273.9 KB. it takes now 45 sec on the same machine without updating links what i have allready done: i searched this mailing list for a similiar problem and found some hints: 1. OpenOffice should be allready opened or use OO-Quickstarter. Opening the *file* is not faster. 2. using autopilot for converting xls files. the file does not open faster. 3. my {HOME}/<ooopath>/user/psprint/pspfontcache has everytime the same size of 21056 and I set to read only. i did not gain perfomance for these special files. 4. Graphics cache: Use for OpenOffice.org 9 -> 20 MB Memory per object 2 -> 8 MB Security/Java disabled Load/Save--Save Size optimization for XML format disabled Load/Save--VBA Properties -- Microsoft Excel 97/2000 "Load Basic code to edit" disabled Load/Save--VBA Properties -- Microsoft Excel 97/2000 "Save original Basic code again" disabled 5. when i copy all tables in a new sxc file, this new file takes 25 seconds to open. but this method has serveral disadvantages: i loose all links to other tables and files. Has anybody a solution to make calc faster for opening files? Has anybody made tests, if it is faster without compressing the xml files or to use an other xml parser? Thank you for any hint in advance. philipp
Created attachment 14237 [details] this is the excel file, with which i made my tests; but there are others too.
Hi Philipp, sorry, but this is neither an defect report nor an enhancement request but a support question. Such questions are answered on the Mailinglist and not on the bugtracking system. I've tried your file and the loading time without updating the links ( not possible as I do not have the files) takes 5 sec for the original Excel file and 9 sec for the sxc one. I think this is not as bad as you described. The system used is an Windows XP Prof. AMD Athlon XP 1500+ with 512 MB RAM and OOo1.1.1 XML based files must be slower on opening because they have to be parsed instead of binary files which only have to be pulled into the memory. Basically using cell formats instead of hard formats would enhance the loading time of documents. Also we are working on the performance of the loading / saving process. Best regards Frank
closed invalid
Hi, regarding the load time after copying all sheets into a new document, you get only the 27 shown Sheets. All hidden Sheets ( from the linked files) are lost and therefore must not be loaded. Frank