Do you mean create records in ESS table, or Execute SQL to the ODBC?
Does the script run on server?
Which data type do you use as primary key in mysql table?
The script runs from filemaker server every 10 minutes!
Takes the MYSQL table empties it and then re-import all the records to a temporary table that ad hoc in-law with the data to be published on the website.
The key is a sequential numeric ID.
The problem is that from the counter of the doors of the applications monitor continues to increment and then reached 65 .... 68000 practically puts Filemaker server on the block and are forced to close and restart all services or reboot the server! !