I have an ESS connection to a hosted MySQL database. I have other TO's to tables on that same ODBC connection, same data source (different table) with hunders of thousands of records, and have no issues.
On one small ESS table (~10k records), as soon as I specify the data source and table name and place the TO in the diagram and save, it locks filemaker for several minutes. It doesn't crash, but there is a 3-5 minute delay before FM will respond again. It will do this randomly throughout the day (was happening to all users for a while and we traced it to this TO). I removed the TO, the problem went away. I re-added it, with no relationships, and the problem is back. It will lock up FM for several minutes, then work for a while until it freezes again for several minutes. I double checked that there is a primary index in place (and there happen to be two additional INDEX indexes on the mysql table).
Not sure where/what to troubleshoot next. Any ideas?