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

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Jul 11 14:27:11 CEST 2012


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

Lionel Elie Mamane <lionel at mamane.lu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|https://bugs.freedesktop.or |
                   |g/show_bug.cgi?id=51976     |

--- Comment #22 from Lionel Elie Mamane <lionel at mamane.lu> 2012-07-11 12:27:11 UTC ---
(In reply to comment #21)
> sberg - IIRC Lionel is fairly convinced this is a Java stack-guard slowness,

At the time of comment 6, this looked like the best guess. Information in later
comments seems to suggest that maybe not, or at least a *different* stack-guard
problem than bug 35023, but it could also be a *different* Java <-> C++
interface problem.

I've a few ideas why it could be slow in general, but none of them explains why
this is a regression in 3.5 with respect to 3.4:

 - HSQLDB I/O is redirected to our ZIP-file structure; unless we cache
   the whole thing, this must be problematic if HSQLDB tries to read the
   *end* of the file or write to the *begin* of the file: the whole file
   has to be (de)compressed.

   This happens in connectivity/com/sun/star/sdbcx/comp/hsqldb,
   git log suggests no change since Oct 2010 there!

 - There seems to be codepaths where information that has *just* been fetched
   is "refreshed" (and thus fetched again) a fraction of a second later.
   But even if there were a regression in that in 3.5, that would be
   a factor 2 or max 5, not the horrible times seen here.

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



More information about the Libreoffice-bugs mailing list