OOo Base / Mysql / JDBC / Ubuntu 9.04 slow slow!!

[ponlerd]

Hi, here is a performance issue (critical!!!)

Mysql Server > ODBC > MS Access front end = running like flying
Mysql Server > JDBC > Openoffice front end on Windows = running acceptable performance
Mysql Server > JDBC or Native Mysql connector > Openoffice front end on Ubuntu 9.04 = super super slow ( screen has to dim down for 5 seconds before running again)

Ubuntu 9.04 alone is quick, everything else in the openoffice suite is ok,
just when base starts getting data from the server, then it is so slow.
On a form, filter by form , slow
On a form, click view data source as table , slow again.


Has anyone has experienced something like this??
Thank you for any help / directions..

Ponlerd

[rudolfo]

As far as I know "retrieving data" from withing Base means that base starts a connection to the mysql database, executes a query and closes the connection. Only the login credentials are cached (that's the "store password" option). But Base doesn't cache connections.

This means with every request from Base the mysql server forks a new child process/thread for the client. You haven't told us on which machine the Mysql server is running. If this is the same Ubuntu 9.04 box there is a small chance that you are short of resources (CPU, memory).

Other things you might consider:

• Domain name resolution: do you use host names or ip addresses in your connect string?
• Check the CPU load and memory consumption on each host
• Network traffic ... use a traffic sniffer (wireshark, tcpdump, ...)
• JDBC will always use TCP, but the mysql native driver might decide to use the UNIX socket

These are just my ideas where I would start tracing the problem.

[Hagar Delest]

Try with the Sun version instead of the Ubuntu one: [Ubuntu] Installing OOo on Debian and Co.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

[ponlerd]

I'll give it a try!