I have a simple web app built in PHP.
There is a data entry form (for entering numeric values). When the user clicks submit, and INSERT statement is executed, and the user is automatically directed (via HTML redirect) to the grid view of said data.
We ran this system off of an older Mandriva 2007 server, and it worked perfectly. Data was immediately entered into the database, and upon viewing the Grid, the data was there.
We've migrated to a new server, and found the following:
-After inserting and redirecting to the grid, the new data is not on the grid
-I immediately check the MySQL database, and see the data is inserted
-If I continuously refresh the PHP grid, within 30-45 seconds, the data appears.
I need to make this data show up immediately. Since the data is in the database, immediately after clicking submit, I'm not sure why the data wouldn't immediately show up on the PHP grid.
I am populating the grid with a simple SELECT statement, that worked perfectly on the last server.
Any thoughts, is there anything about the newer MySQL or Apache (PHP) that would explain this, perhaps a setting I need to change?