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

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 52170
           Summary: An extremely slow search/browse table in embedded
                    HSQLDB
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.2 release
          Platform: x86 (IA32)
        OS/Version: All
            Status: UNCONFIRMED
          Keywords: regression
          Severity: major
          Priority: high
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: lionel at mamane.lu
                CC: admin at timbacore.co.za, iplaw67 at yahoo.co.uk,
                    lionel at mamane.lu, michael.meeks at novell.com,
                    pmladek at suse.cz, robert at familiegrosskopf.de,
                    sbergman at redhat.com, serval2412 at yahoo.fr,
                    vstuart.foote at utsa.edu, vulcain at gmx.com
        Depends on: 51239
            Blocks: 37361, 51976


+++ This bug was initially created as a clone of Bug #51239 +++

Text by David:

Libre Office Base is extremely slow when sifting through the database table. I
have a table with 30000+ entries which can take up to 20 minutes to sift
through. Generally I can use the slider to move to the vicinity in the table
where I want to be, but this freezes the table for a while. At its worst, the
base table crashes and closes LibreOffice entirely, at times at the cost of the
entire file.
This is Linux specific as Windows does not share this problem.
Previous versions (3.x) of both Open and Libre Office also had this problem,
but with Linux, I "downgraded" my Java Runtime to 1.6.22 and this would solve
the problem. (Actually, I would manually install the 1.6.22 version to my /opt
folder and guide Libre Office to it.) Since 3.5, this no longer works either.
I previously ran Linux Mint 9 with Libre Office 3.5.4 installed from the
command line. I then upgraded to Linux Mint 13 with LibreOffice 3.5.2.2 as the
resident office suite. Both have this problem. I ran Open Suse 11.3 on another
machine and installed Libre Office 3.5.4... and same problem again. However,
Windows XP and 7 do not share this, regardless of the JRE installed.
I have registered with rapidshare and will upload a watered down version of the
bug as soon as possible. Details to follow.


I can however confirm that no JDK/JRE since 1.6.22 has solved this problem (And
I have downloaded 1.7 recently to test) and whatever happened in the
LibreOffice 3.5x code, has significantly changed the Base / Java operation that
no JRE can help anymore.
I have also downloaded Open Office Org 3.4 and it does share the original bug
with base, but JRE 1.6.22 still keeps base running faster on OOo.
It is also not an Ubuntu specific bug, as Opensuse 12.1 and 11.3 both share it
in their versions of LibreOffice/ OpenOffice. (I am the IT guy for a small
company running OpenSuse 11.3 as their OS, and 12.1 on the file/ print server
and all these laptops share the same problem when testing Base.)
Also, the windows (WIN32) versions do not share this problem, so it seems the
bug is specific to the combination of Linux / Java / Base. I tested it on a 
1Ghz P3 running Windows XP pro with LibreOffice 3.4 and JRE 1.6.31 and it was
significantly faster than my Core 2 duo laptop running LibreOffice 3.5.2 on
Mint 13...

See attachment 63259 to bug 51239 for reproduction file.


All testers: *please* report in this bug _only_ for tests with versions where
bug 51239 is fixed (at this point I hope for 3.5.6 and 3.6.0.rc2) or 47520
*not* fixed (that is: 3.5.4 or older)! Please always clearly say:

1) which platform
2) JRE version
3) LibreOffice version

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