Delayed transactions INSERT/UPDATE with PHP
Posted on 2012-04-05
I have a PHP script on our internet server that sends either an INSERT or UPDATE SQL statement to a table in a small local database. I've tried this with mySQL and Postgress but get exactly the same weird effect.
Firstly, my PC based app sends the data to the PHP script which loads it into the table every 10 seconds in a sequence of about 50 transactions. I then close the app.
In the following hour new records are magically inserted or updated even though nothing is calling the PHP script.
I can only assume that PHP transactions that were made have somehow been delayed by up to an hour coming in randomly, out of sequence, every few minutes and changing the table.
Any help with understanding what's going on and how to solve it much appreciated.