desktop-packages team mailing list archive

[Ulf Mehlig <ulf.mehlig@xxxxxxx>]

** Attachment added: "log file (gzipped) showing queries issued during opening of form"
   https://bugs.launchpad.net/bugs/835662/+attachment/2323875/+files/postgresql-jdbc.txt.gz

-- 
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/835662

Title:
  LibreOffice Base forms become extremely slow after switching from
  currently unusable PostgreSQL SDBC driver to JDBC

Status in “libreoffice” package in Ubuntu:
  New

Bug description:
  We have been using OpenOffice/LibreOffice Base and SDBC for a long
  time to access our PostgreSQL databases. After SDBC has apparently
  gone defunct (tables are all read only), we had to switch to JDBC.
  However, opening and using forms via JDBC is extremely slow. Following
  suggestions from the PostgreSQL JDBC mailing list, I logged the
  queries issued by both drivers (log file is attached). While both
  drivers spend only a short while doing queries (JDBC: 0.65 s, SDBC:
  0.62 s in my test case), the difference in total time used is huge (at
  least 49 s with JDBC, 2 s with SDBC). It looks to me that JDBC itself
  cannot be blamed for this bad performance, so I consider this
  behaviour as a bug of LibreOffice base.

  Please let me know if you do need any additional information, for
  example about the used database tables. The table of the form I used
  for the attached example log is rather unwieldy (many columns), but it
  has only ~5.500 rows. Anyway, the effect is observable also with much
  simpler tables and the respective forms.

  I hope you will be able to track this down ...,
  Cheers, Ulf

  ProblemType: Bug
  DistroRelease: Ubuntu 11.04
  Package: libreoffice-base 1:3.3.3-1ubuntu2
  ProcVersionSignature: Ubuntu 2.6.38-11.48-generic 2.6.38.8
  Uname: Linux 2.6.38-11-generic x86_64
  Architecture: amd64
  Date: Sat Aug 27 17:29:31 2011
  EcryptfsInUse: Yes
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
  ProcEnviron:
   LANGUAGE=en_GB:en
   PATH=(custom, user)
   LANG=de_DE.UTF-8
   LC_MESSAGES=en_GB.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to natty on 2011-04-29 (119 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/835662/+subscriptions