FM9 - poor SQL performance on a shared MySQL-server

[markus_vienna]

Hello!

is anyone using FM connecting with MySQL 5, on a shared MySQL-Server from your internet-provider?

Do you have good response times?

I never found anyone talking about poor response times...

I have:

3 FM Clients (Windows, OS X)

SQL-data on a shared host

connecting: with MySQL ODBC 3.51

xDSL: 2048/512

I have a small database with customers, and often - usually after a longer break -, when we go back to work and click on any field of the current record, FileMaker starts a "Search" and needs 15 to 60 Seconds to be able to edit the current record again.

I have no idea, why sometimes it‘s possible to go on immediately and sometimes he needs so much time.

Today I tried the same with FileMaker Server, but again, very long brakes from time to time.

Any ideas?

thank you, Markus