I am running WAMP on my pc. Works great. I have 1 php routine that reads 5,000 records from 1 mysql database and writes 12 times that number to another mysql database. I use the data from the 5,000 names and add to it to create the 12,000 records in the 2nd database. This works fine on GoDaddys servers but it times out after 30 se3conds on my local machnine when I test.
I researched the problem and found KeepAlive and KeepAlive timeout directives. I set KeepAlive to ON in the httpd.conf. I set KeepAlive to 60 but the inserts still timeout after 30 seconds.
KeepAlive On KeepAliveTimeout 60
How does one go about increasing the time allowed for a bunch of mysql inserts?
The apache version is 2.2.17. The mysql is 5.1.53 and the php is 5.3.4. I have tried to run the updates on IE 9, Google Chrome v24, Firefox v18, and Safari V5. All timeout.
How can I keep it going until the inserrs are done?