openjdk team mailing list archive
-
openjdk team
-
Mailing list archive
-
Message #07278
[Bug 686028]
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 OpenJDK,
which is subscribed to openjdk-6 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