troubleshooting Question

PHP Website / MySQL Database Delay

Avatar of compsol1993
compsol1993 asked on
PHPMySQL ServerWeb Development
8 Comments1 Solution216 ViewsLast Modified:
Hello,

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?

Thanks
ASKER CERTIFIED SOLUTION
Francisco Igor
Software Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros