GNOME Bugzilla – Bug 515120
gnumeric is slow on my machine
Last modified: 2009-01-26 18:42:00 UTC
Please describe the problem: i have a spreadsheet where gnumeric is quite sluggish. i'm assuming it's due to the shortcomings of my machine and would like someone else to verify that more up-to-date hardware will solve my problem. i'll try to attach the spreadsheet to this bug. i realize the it does a lot of calculations. the processor gets hammered when i do a recalc or other stuff. i'm just hoping a new PC will solve the problem if it's not a problem with gnumeric. hardware: 5 yr old PC with 2.26 ghz Pentium 4, 512MB ram running Ubuntu 7.10 (Gutsy), Gnumeric 1.7.11 adding ram is not cost effective because all memory slots are full and the memory is RDRAM (expensive - might as well replace the machine). Steps to reproduce: 1. press F9 and see how long it takes to recalculate the worksheet 2. insert a row into between rows 17 & 18 in the Data tab Actual results: it takes a long time to complete Expected results: it would take a considerably shorter time Does this happen every time? yes. Other information: it's been suggested that swapping may be the culprit. normally, i have firefox open at the same time as gnumeric and the swap file is in use, according to top. but, i ran a test with just gnumeric loaded, no firefox or other apps. i turned the swap file off and back on to reduce usage down to 0. the actions described above still took a long time. top showed swap file usage at 0kb.
Created attachment 104678 [details] spreadsheet that gnumeric is sluggish with
recalculation on Current: 3 seconds insert row: 25 seconds for the first row, 10 seconds for the next ones. this is clearly to slow, on the otehr hand there are lots of graphs that are likely to have to be recalculated on an insert. this is on a quad dual-core opteron 64bit 2412.394 MHz 8Gb memory total.
The patch over at http://bugzilla.gnome.org/show_bug.cgi?id=567389#c13 seems to row insertion down to ~4s for me.
I'd like to try the patch but don't know how. I currently get the latest version of gnumeric by executing the following commands for libgsf, goffice and gnumeric: > svn up > ./autogen.sh > make > sudo make install sometimes i then get an error about libspreadsheet.so which i solve with the following: > sudo ldconfig
> sudo ldconfig (Needed after a new major version of a library is installed.) I'd like to try the patch but don't know how. 1. Download patch file "ppp". 2. cd gnumeric-to-level 3. patch -p0 <ppp 4. make
Patch committed. An quick inspection of the workbook suggests that it probably triggered the same issue that the patch fixed. Verification would be nice.
I see an improvement from 170 seconds down to 36 seconds. I'm using a Via 1.5 Ghz C7-M processor.