ODBC-connection sometimes slow

[markus_vienna]

Hello!

I‘m good in Filemaker, but new to the integration of a mySQL-database.

I‘ve done already some research, but don‘t find real good answers.

I‘ve read here already that Filemaker is not good to use as a frontend, but that is what I exactly wanted to do...

We have a small company with just 100-1000 records in 2 tables, so I thought that would be easy to do.

Usually, opening the file, the SQL-records are immediately shown. But later the day, there are sometimes pauses from 20 to 60 seconds, when a change to a field is updated, or when doing a record-search.

I cant reproduce this problem, but it happens quite often, when I try to work again after a break of a quarter or hour.

Are there any caching possibilities? Is there anything to configure on the MySQL-server?

Thanks a lot for answers!

(FM 9.03 standard + Advanced (PC + Mac), ODBC 3.51.22 on a PC, MySQL 5.0.51)

[Linux on Unix Action Hero]

We're experiencing very similar symptoms in a purely FM environment, with the same kind of functionality. My suspicion is that it's largely due to an underpowered host server (ie, the one that runs FileMaker). Our FM db is about 40k rows, about 45 tables, and running on a 1.2GHz G4 w/ 1.5G (10.4 w/ FMS9). The system gets fairly heavily stressed during a pretty simple query.