[Solved] Base-Mysql extremly slow with java7

[zeke99]

I have a Mysql database 5.5.29-0Ubuntu0.12.10.1.
Using aoo base 3.4.1 as gui connecting to the mysql with com.mysql.jdbc.Driver (mysql-connector-java-5.1.23-bin.jar).

After changing OS from Xubuntu to Linuxmint 14.1 it took approx. 2 minutes to open a table.
Tested changing from 64-bit to 32-bit, same result. Tested different jdbc-drivers, same result.
Installed java6 instead of java7 and, voila, back to normal (appr. 10sec to open a table, which isn't very fast but acceptable).

I can stay with java6 but if someone know about some easy workaround ..

[DACM]

It's interesting to see that the issue with Linux+JDBC is so widespread. The JRE 6 workaround is the current fix for slow database response under Linux.

But you went to considerable effort to get to that solution. So I have to ask, did you run into problems or limitations with the native-Office driver (SDBC) for MySQL?
...

[zeke99]

Yesterday I tried to get odbc going but odbcconfig won't start (due to gnome fooling around with gtk maybe??).
Today I read your post and downloaded aoo-my-sdbc. It was like changing car from my japanese pickup to my wifes bmw M8.
Really a lot, lot, lot faster. Nice.
When I started this project a couple of years ago the odbc- and jdbc-connection was the choices you have and jdbc was the first one working so ever since ...

[salrandazzo]

Hi guys.
I'm using OO 4.0.0 under Windows7, trying to connect a remote MySQL, using aoo-my-sdbc connector. It works, yes, but SO SLOW.
It takes some 90" just to show the table list (only one table present so far), and another 120" just to display the table content, i.e. three rows.
I tried with other tools, like MySQL-Front, and it works in a matter of seconds....
What to do?
Thanks a lot for any advice.
Salvatore.

[craig_millsy]

I am experiencing this issue also. Any further developments?