[Resolve Work Order Page Timeouts](https://freelancer.com/projects/40729077.html)

[Resolve Work Order Page Timeouts](https://freelancer.com/projects/40729077.html) Our Work Order page is part of a PHP-based web application running on a MySQL database. Under load it frequently times out; when that happens only some of the selected spare-part lines are written to the database, throwing our inventory counts off and forcing manual corrections. I need you to trace the root cause, remove the timeout, and guarantee that every Work Order either commits completely or not at all. That may involve query optimisation, refactoring the save routine, adding proper transactions, or introducing asynchronous calls—whatever the cleanest, most maintainable fix proves to be. Acceptance criteria • The page loads and saves in under five seconds with our current data volume (≈300 line i...