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)
see also
https:/