Fixed as <http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-5&id=cbc1ddba1bbe8843e0b31d39cb5c04f7b6518925> "Confine JDBC driver to thread-affine apartment for Java 6 performance."
>From <http://nabble.documentfoundation.org/Trying-to-diagnose-base- running-extremely-slowly-tp3426499p3653136.html>: "One rather easy fix would be to confine the com.sun.star.comp.sdbc.JDBCDriver UNO code to a thread-affine apartment, see the attached patch. That way, all code related to this UNO service (which is the code that calls Attach/DetachCurrentThread so frequently and thus causes the performance degradation) is run in a single, dedicated thread. "That thread is guaranteed not to be the main thread (as the thread-affine apartment explicitly creates it), so JVM versions that include the fix for <http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6978641> 'Fix for 6929067 introduces additional overhead in thread creation/termination paths' (which significantly reduces the overhead of Attach/DetachCurrentThread for all but the main thread again) should return to an acceptable performance. Trying it out on Fedora 16, which includes version 1.6.0_22 of OpenJDK, the patch noticeably improves performance of the test scenario described at <https://bugzilla.redhat.com/show_bug.cgi?id=661738#c0>. [...] "I did not find problems with using the thread-affine apartment, but then again my Base skills are virtually non-existent, so this would probably need some QA. However, there is also already another SDBC driver that uses the thread-affine apartment, namely the Windows-specific ADO driver (com.sun.star.comp.sdbc.ado.ODriver)." So, please somebody QA the Base JDBC driver thoroughly. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/686028 Title: Base tables load sort slow bad jre Status in LibreOffice Productivity Suite: Fix Released Status in The OpenOffice.org Suite: Unknown Status in Sun Java SE Development Kit: New Status in “libreoffice” package in Ubuntu: Confirmed Status in “openjdk-6” package in Ubuntu: Triaged Status in “openoffice.org” package in Ubuntu: Won't Fix Status in “sun-java6” package in Ubuntu: Confirmed Status in “libreoffice” package in Debian: Fix Released Status in “openjdk-6” package in Debian: Confirmed Status in “openjdk-7” package in Debian: Confirmed Status in “sun-java6” package in Debian: Fix Released Bug description: Binary package hint: openoffice.org 1) lsb_release -rd Description: Ubuntu 11.10 Release: 11.10 2) apt-cache policy libreoffice-base libreoffice-base: Installed: 1:3.4.4-0ubuntu1 Candidate: 1:3.4.4-0ubuntu1 Version table: *** 1:3.4.4-0ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.4.3-3ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages apt-cache policy openjdk-6-jre openjdk-6-jre: Installed: 6b23~pre11-0ubuntu1.11.10 Candidate: 6b23~pre11-0ubuntu1.11.10 Version table: *** 6b23~pre11-0ubuntu1.11.10 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages 500 http://security.ubuntu.com/ubuntu/ oneiric-security/main i386 Packages 100 /var/lib/dpkg/status 6b23~pre10-0ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages 3) What is expected to happen in Base via the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/686028/+attachment/2166527/+files/test.odb && lobase -nologo test.odb click Tables icon on left -> secondary click Books -> click Open is clicking page down within the table itself moves instantly or near instantly. 4) What happens instead is it takes 5 seconds for it to go down 11 rows. Problem reproducible using: jre-6u23-linux-i586.bin jre-6u24-linux-i586.bin jre-6u25-linux-i586.bin jre-6u26-linux-i586.bin jre-6u27-linux-i586.bin jre-6u29-linux-i586.bin jre-6u30-linux-i586.bin *jre-6u28-linux-i586.bin not found on Oracle archive page. Original Reporter Comments: I note that jre was upgraded recently and that was when the problem began. My conclusion is that there is a problem with the jre installed recently: ii openjdk-6-jre 6b20-1.9.2-0ubuntu1~10.04.1 ii openjdk-6-jre-headless 6b20-1.9.2-0ubuntu1~10.04.1 ii openjdk-6-jre-lib 6b20-1.9.2-0ubuntu1~10.04.1 Upstream bug link for sun-java6-jre and openjdk-6-jre (as openjdk bugzilla not fully operational yet): http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=7024514 WORKAROUND: Go to http://www.oracle.com/technetwork/java/javasebusiness/downloads/java- archive-downloads-javase6-419409.html#jre-6u22-oth-JPR and download jre-6u22-linux-i586.bin, then via the Terminal: sudo mv jre-6u22-linux-i586.bin /opt && cd /opt && sudo sh jre- 6u22-linux-i586.bin open the desired Base file -> Tools -> Options -> Java -> click 1.6.0_22 radio button -> close all LO applications running -> re-open Base file and it works fine. ProblemType: Bug DistroRelease: Ubuntu 10.04 Package: openoffice.org-base 1:3.2.0-7ubuntu4.1 ProcVersionSignature: Ubuntu 2.6.32-26.48-generic 2.6.32.24+drm33.11 Uname: Linux 2.6.32-26-generic i686 Architecture: i386 Date: Mon Dec 6 10:31:57 2010 InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429) ProcEnviron: PATH=(custom, user) LANG=en_US.utf8 SHELL=/bin/bash SourcePackage: openoffice.org To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/686028/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
