Servoy GLACIALLY slow talking to mysql

Classic Servoy
1

I have a local Servoy install on my MacBook Pro (Servoy version 4.1.7 -build 690). It is also deployed to my customer as a running solution.

In both cases, Servoy connects to Sybase and MySQL. For the customer, everything works fine.

On mine, the connection to MySQL is unimaginably slow (minutes to load a form containing 3 mysql records, from a table that has 4 columns). If you click a tab containing data from the table, you literally wait minutes before it will show.

localhost:8080/servoy-admin/performance shows no problems (see attached).

My Servoy log shows no problem:

2014-01-12 12:30:30,503 ERROR [Thread-3] com.it2be.components - (No such license file or directory)
2014-01-12 12:30:36,840 ERROR [Thread-3] com.it2be.components - (No such license file or directory)
2014-01-12 12:30:39,915 WARN [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Column name ‘website_historical_presence_flag’ from table ‘stock’ is too long (>30 chars) – this is not supported by all databases
2014-01-12 12:32:31,172 ERROR [Thread-13] com.it2be.components - Failed processing list of available components…

2014-01-12 12:33:49,314 ERROR [Thread-3] com.it2be.components - (No such license file or directory)
2014-01-12 12:33:51,802 ERROR [Thread-3] com.it2be.components - (No such license file or directory)
2014-01-12 12:33:53,839 WARN [TaskExecuter[0]] com.servoy.j2db.persistence.Server - Column name ‘website_historical_presence_flag’ from table ‘stock’ is too long (>30 chars) – this is not supported by all databases
2014-01-12 12:35:49,850 ERROR [Thread-33] com.it2be.components - Failed processing list of available components…

My MySQL deployment is in MAMP.

During the hang, both Servoy and mysqld are on or around 0% cpu

I am not sure where to look to get this resolved. Does anyone have any ideas?

Thanks

Bevil

Screen Shot 2014-01-12 at 13.12.41.png
Screen Shot 2014-01-12 at 13.12.41.png3176×2576 1.46 MB

2

Just to add, during the hang, NOTHING is consuming any cpu, my highest at the moment is 5%

3

Looks like a JDBC problem, check that you are using the correct JDBC driver for your myqsl version. A good start point for debugging would be the mysql log.

4

Thanks Nicola

I have now reinstalled MySQL entirely, and replaced my jdbc driver with a fresh (updated) version.

I have EXACTLY the same problem still. If I switch between tabs from one tab which has Postgres data to a tab that has related MySQL data (and only three rows in four columns), it takes more than 2 minutes to show the new tab (it eventually does).

I have never seen Servoy do anything this slowly.

The queries of the MySQL database via terminal are instant. Similarly via SequelPro. Only servoy is impossibly slow.

The form I am showing has no events, and no calculations that are triggered.

5

I have fixed this. It was my fault. I was calculating a url for an image which is on the customer’s live server, rather than to a local server.

My fault… Sorry…

:(

6

np