[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=51239

--- Comment #23 from Alex Thurgood <iplaw67 at yahoo.co.uk> 2012-07-12 06:31:04 UTC ---
(In reply to comment #21)
> Hi Alex, the profiler report looks rather interesting (thanks so much for
> trying all these tools at LibreOffice !). Having said that - its' hard for me
> to see where the profiler thinks most of the time has gone ... is there any
> %age estimation / call-count or absolute time measurement in there to use ? I
> just saw traces.
> 

Hi Michael,
Errm, probably, but I'm still trying to understand how to use the tool in the
first place :-) Apple's Instruments.app is a nice graphical inspection tool,
but it seems that you can only save the information as a bundle which can then
only be read by someone else if they have the same tool. It does all sorts of
wonderful time slice analysis and can even link that to the underlying source
code to get to the calls that appear to be causing the problem. I will have to
try it out with a version of LO from master and my git sources to see if I can
make anything sensible/useful out of it.


> (assuming the symbols are remotely reasonable).
> 
> Is it possible that there is some horrible leak / performance problem /
> re-marshalling in the inter-apartment code ?

In a graphical malloc trace, the loading of the database file causes a
significant and constant increase in memory consumption, and this actually
caused both the Instruments.app and LO to to crash in the end as all system
resources were finally consumed.

I will try and post some screen captures to see if the information I see on
screen can bring anyone any further.


Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.