From: | Ulf Mehlig <ulf(at)ufpa(dot)br> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | jdbc and LibreOffice on Ubuntu: slow performance |
Date: | 2011-08-25 14:33:51 |
Message-ID: | 1314282830.3433.18.camel@ulf-tab |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
----------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Maciek Sakrejda | 2011-08-25 16:45:09 | Re: jdbc and LibreOffice on Ubuntu: slow performance |
Previous Message | Dieter | 2011-08-25 10:41:44 | SQL_ASCII charset conversion |