Обсуждение: jdbc and LibreOffice on Ubuntu: slow performance

Dear all,

does anybody have experience with OpenOffice/LibreOffice and
JDBC-PostgreSQL? We recently had to switch from the "native" OpenOffice
SDBC driver to JDBC for accessing our PostgreSQL databases (8.4) com
LibreOffice module lobase and experienced a dramatic slowdown of the
performance of database forms; loading a form for a single table with
about 5000 rows needs more than a minute, and search operations are also
very sluggy.

This might have to do with the number of rows fetched by default into
the form interface -- if this seems plausible to you, is there a
possibility to configure JDBC/LibreOffice to achieve a better
performance? If not, what are our options to find out what exactly
causes the bad performance?

I hope you can help -- thanks in advance,
Ulf

Server OS: Debian stable with standard PostgreSQL 8.4
Client OS: Ubuntu 11.04
Client UI: standard LibreOffice 3.3.3 (OOO330m19 (Build:301)) and
           JDBC driver postgresql-9.0-801.jdbc4.jar

--
 Dr. Ulf Mehlig · Laboratório de Biologia Vegetal
 Instituto de Estudos Costeiros (IECOS)
 Universidade Federal do Pará, Campus Bragança · Brazil
----------------------------------------------------------------------

> This might have to do with the number of rows fetched by default into
> the form interface -- if this seems plausible to you, is there a
> possibility to configure JDBC/LibreOffice to achieve a better
> performance? If not, what are our options to find out what exactly
> causes the bad performance?

The most likely bottleneck is one due to differences in the queries
actually issued (especially considering that parameters could be
handled differently), such as prepareThreshold issues.

Edit your postgresql.conf and set log_min_duration_statement to zero,
walk through a couple of use cases with the old driver (if possible),
then with the new driver, and compare the durations. If you can't use
the old version anymore at all, just look for the longest durations
with the new driver, or durations corresponding to a particularly slow
form.

---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com