desktop-packages team mailing list archive

[Ulf Mehlig <ulf.mehlig@xxxxxxx>]

Public bug reported:

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)

** Affects: libreoffice (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug natty

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