openjdk team mailing list archive

[Sbergman <686028@xxxxxxxxxxxxxxxxxx>]

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