# Servoy GLACIALLY slow talking to mysql **URL:** \ **Category:** Classic Servoy\ **Created:** [January 12, 2014, 1:18pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726 "2014-01-12T13:18:26Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![bevil](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@bevil](https://forum.servoy.com/u/bevil)\ **Post date:** [January 12, 2014, 1:18pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726/1 "2014-01-12T13:18:26Z")
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](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/1X/24724274db32b1caf7eb0eef7ca3f78fd7b78c70.png) ---
**Author:** ![bevil](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@bevil](https://forum.servoy.com/u/bevil)\ **Post date:** [January 12, 2014, 1:21pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726/2 "2014-01-12T13:21:59Z")
Just to add, during the hang, NOTHING is consuming any cpu, my highest at the moment is 5% ---
**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\ **Post date:** [January 12, 2014, 7:28pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726/3 "2014-01-12T19:28:09Z")
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. ---
**Author:** ![bevil](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@bevil](https://forum.servoy.com/u/bevil)\ **Post date:** [January 14, 2014, 3:53pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726/4 "2014-01-14T15:53:26Z")
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. ---
**Author:** ![bevil](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@bevil](https://forum.servoy.com/u/bevil)\ **Post date:** [January 14, 2014, 4:08pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726/5 "2014-01-14T16:08:13Z")
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… ![:(]( "Sad") ---
**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\ **Post date:** [January 14, 2014, 4:10pm UTC](https://forum.servoy.com/t/servoy-glacially-slow-talking-to-mysql/17726/6 "2014-01-14T16:10:32Z")
np