Hi Michael,

Appreciate your feedback.
I ran callgrind but no output on screen and 0 bytes files generated. I can run 
it on non-LO exe.
I'll compile LO with --enable-debug and see if situation improves. Please 
advise if other steps might be needed.

What's your hunch about how long it should take to update 60K cells with 
{getCellByPosition(ii,jj) and setValue() } ?
Moving from interprocess bridge speeded it up for me and I might have given up 
on further speed-up too quickly. I can certainly use further speedup.

Thanks
Neeraj
-----Original Message-----
From: Michael Meeks [mailto:[email protected]]
Sent: Thursday, January 10, 2013 4:45 AM
To: Rai, Neeraj [ICG-MKTS]
Cc: '[email protected]'
Subject: RE: [libreoffice-dev] - questions about calc extension


On Wed, 2013-01-09 at 23:18 +0000, Rai, Neeraj wrote:
> I looked a little more into your code and copied the getactiveSheet function. 
> Now it takes 12s. I am happy.
> Sorry for the spam - you have good code sitting there.

        12s sounds like a long time to me ;-> If you can run your macro under
callgrind:

        export OOO_DISABLE_RECOVERY=1
        valgrind --tool=callgrind --simulate-cache=yes  \
         --dump-instr=yes ./soffice.bin -writer --splash-pipe=0

        (needs write-permission to the installed libreoffice directory to drop
it's callgrind.12345.txt file)

        Then perhaps kcachegrind will show you something interesting for your
use-case.

        HTH,

                Michael.

--
[email protected]  <><, Pseudo Engineer, itinerant idiot

_______________________________________________
LibreOffice mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Reply via email to