[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Andre changed: What|Removed |Added Severity|major |normal --- Comment #14 from Andre --- I looked into the bug document and found that it is not as simple as it looks: - It has 23 sheets - Each sheet has a row with a repeat count of 1048567: The row may be empty but it still results in a couple of function calls per repeated row. For these reasons I set the importance to normal. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Andre changed: What|Removed |Added CC||awf@googlemail.com --- Comment #13 from Andre --- Sorry for the delay. I was on vacation. (In reply to Clarence GUO from comment #7) > I debugged code and find 80% time are spent on calling XML_Parse(called in > sax). XML_Parse is a third party code of expat. 80% inclusive or exclusive function calls? When inclusive then this is to be expected when loading an XML document and no indication for a problem of expat. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 --- Comment #10 from Clarence GUO --- I also tested on a MAC 10.5.8, Intel 2GHz Core 2 Duo, 2G RAM, haven't find performance gap between OpenOffice3.3 and Apache OpenOffice4.0, the time are both 6+s for loading sample from a retarted soffice process and 4+s for loading sample from an existing soffice process. I haven't try Linux, but suppose it is Win7 only. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 --- Comment #9 from Clarence GUO --- Yes, Oliver, you are right. It's system dependent. I also tested on Win7 64 bit, Intel Core (TM) i7 i7-3700, 3.4GHz, 16G RAM, then time is 5+s, and 3+s for first open the sample when restart soffice process and for open the sample on an existing soffice process. But on AOO 3.4.0, time is around 2-3s and 1-2s. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Oliver-Rainer Wittmann changed: What|Removed |Added CC||o...@apache.org --- Comment #8 from Oliver-Rainer Wittmann --- I did no real profiling - I just looked at the system watch. On my system (64bit Windows 7, Intel Core (TM) i7-2720QM CPU 2.20GHz, 12GB RAM) I have: - AOO 3.4.1 --> 2-3 seconds - AOO 4.0.0 --> 5-6 seconds - trunk build from build bot (rev. 1521488) --> 5-6 seconds. Thus, I can still confirm this issue. May be the issue is system-dependent. - Windows 7 (Rainer and myself) --> reproducible - Windows XP (Clarence) --> not reproducible @Petr Vones: Which version of Windows you are using? -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Clarence GUO changed: What|Removed |Added CC||clarence.guo...@gmail.com --- Comment #7 from Clarence GUO --- I think it is not a regression. I tested both 3.4.0 and 4.0 on my machine, Intel Core(TM2) Duo CPU E6750 2.55 GHz, 1.97 GHz, 2G RAM, Windows XP, follow below steps. I tested several times and get an average time. Load file after restart soffice process: Insure there's no soffice process in task manager, if there is, kill it, then start AOO, load file from menu, File->Open, on 3.4, consuming time is 3.482s; on 4.0, time is 3.082s Load file from an existing soffice process: Afterwards, open the sample from menu File->Recent Files, on 3.4, consuming time is 2.538s, on 4.0, time is 2.53s. I cannot see significant gap between 3.4.0 and 4.0. I note many of you mentioned first attempt will be 6-7s. I also find when I first start AOO then do first attempt, the time will be 6-7s, but once exit from AOO even terminate the process in task manager and restart AOO then load again, the time will be 3+s. This phenomenon I can find on both 3.4.0 and 4.0. So I think there is no regression. I also tested LibreOffice. First run LibreOffice4.1, first attempt is around 6s too. Then terminate the process and restart LibreOffice, loading the file also need 3+s. The result is same with AOO4.0 so far. But the difference is afterwards once load the file again from menu File->Recent Files, LibreOffice will use only 0.5s, but AOO4.0 needs 2+s. I debugged code and find 80% time are spent on calling XML_Parse(called in sax). XML_Parse is a third party code of expat. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Oliver-Rainer Wittmann changed: What|Removed |Added Keywords||regression Latest|--- |4.0.0 Confirmation on|| --- Comment #6 from Oliver-Rainer Wittmann --- Without accurate time keeping I can confirm that the document needs more time for loading in AOO 4.0.0 than in AOO 3.4.1 on my system. --> adding keyword regression -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Edwin Sharp changed: What|Removed |Added Status|UNCONFIRMED |CONFIRMED CC||el...@mail-page.com Ever confirmed|0 |1 --- Comment #5 from Edwin Sharp --- 7 seconds on Rev. 1507307 Win 7. Intel i3 2.93GHz 4GB RAM -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 --- Comment #4 from Petr Vones --- Is there any way to record a macro by steps performed in the OO (the same way like MS Office does) ? I could easily record the steps how to create such slow document. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 --- Comment #3 from Rainer Bielefeld --- 3s with AOO 3.4.0, also bad, but only half time that AOO 4 needs Strange, was there any kind of cache or similar enduring also OOo termination? OOo 3.1.1 and 2.0.2 also needed app. 7s for first attempt to open the document, but all later tests only took 3s. @pet...@mujmail.cz Thank you for additional info -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 --- Comment #2 from Petr Vones --- I have been experimenting with it for a while. I guess that important parts is to use column formatting (B column in my sample) for calculated SUM column (E1 cell in my sample) and create another calculated cell based on the SUM cell result (E2 cell in my sample) with formatting as well. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
[Bug 122911] Slow for particular simple 11KB ODS spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=122911 Rainer Bielefeld changed: What|Removed |Added CC||rainerbielefeld_ooo_qa@biel ||efeldundbuss.de Summary|Slow loading of simple 11KB |Slow for particular simple |spreadsheet in ODS format |11KB ODS spreadsheet OS|Windows XP |Windows, all --- Comment #1 from Rainer Bielefeld --- Steps how to reproduce Reproducible with "AOO 4.0.0-Dev – German UI / German locale [AOO400m3(Build:9702) - Rev. 1503709 (2013-07-17) ]" on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profile: AOO needs 7 seconds to open reporter's sample document, LibO 4.0 needs 1/2s Not a general problem, a self created sample document similar to reporter's open's fast as lightning. @Petr Any Idea what in your document might cause the problem? -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.