Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi Kohei,

Using unlockController/lock brought down the time from 12sec to 3sec. Using DataArray brought it 
down to 14ms!
 Thanks for the tips. Great thing about starting with bad code is that I get to feel happy when it 
improves :-)

Hi Michael,

Who would have thought it was a script :-) Maybe 0 bytes callgrind should have given me a hint.
I am running callgrind now. Although, I don't need to based on above numbers, I am sure I'll write 
the next code as badly and will need it soon.
I never said in the email that I was running the wrapper but you figured it out anyway.
Thanks for catching it.

You guys are great.
Neeraj

-----Original Message-----
From: Michael Meeks [mailto:michael.meeks@suse.com]
Sent: Thursday, January 10, 2013 11:34 AM
To: Rai, Neeraj [ICG-MKTS]
Cc: 'libreoffice@lists.freedesktop.org'; Kohei Yoshida
Subject: Re: [libreoffice-dev] - questions about calc extension


What's your hunch about how long it should take to update 60K cells with 
{getCellByPosition(ii,jj) and setValue() } ?

        It should be ~instant - sub-second anyhow; it's an analog of loading
values from ODS. Kohei's suggestions are great:

On Thu, 2013-01-10 at 10:59 -0500, Kohei Yoshida wrote:
2) Try lockControllers() and unlockControllers() to disable/enable
repainting while updating cell values.  The example of these methods
should be in my xcalc.cxx file I referenced earlier.

        You'd need to run callgrind like this:

export OOO_DISABLE_RECOVERY=1
valgrind --tool=callgrind --simulate-cache=yes --dump-instr=yes ./soffice.bin

        ie. on the soffice.bin not the wrapper script ;-)

        HTH,

                Michael.

--
michael.meeks@suse.com  <><, Pseudo Engineer, itinerant idiot


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.