Problems with timeout and MySQL
Posted by: Resurgent (81.5.148.---)
Date: August 03, 2012 01:31PM

Hi there,

I am currently using WAMPServer 2.2 on a LAN for the purposes of an internally accessible web based application.

I am currently trying to update one of my tables with data from a CSV file.

When I iterate across the CSV file without making any MySQL queries, all of the data is displayed.

However, if I iterate across the CSV file whilst updating, after approximately 500-600 records, it timesout.

I have therefore set KeepAlive to On in my httpd.conf and php_value max_execution_time -1 in my .htacess within the directory of the relevant file. I merely get a rotating loading icon in Chrome, and the page refuses to load.

Any ideas?

Many Thanks.



Edited 1 time(s). Last edit at 08/03/2012 01:42PM by Resurgent.

Options: ReplyQuote
Re: Problems with timeout and MySQL
Posted by: stevenmartin99 (Moderator)
Date: August 03, 2012 03:47PM

max execution time should be 0 , not -1 for infinity

php_value max_execution_time 0

are you sure this is a php error? maybe its coming from phpmyadmin whish has its own timeout set.. thats if you are using phpmyadmin to import.. its not stated what you are using

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Problems with timeout and MySQL
Posted by: RiggsFolly (---.as13285.net)
Date: August 03, 2012 03:51PM

For a long running script try upping the max_execution_time

max_execution_time= 5000 or larger if necessary

Not sure what -1 would do but 0 (zero) may work to remove any limits completely



Dont think the apache keep-alive is your problem set that back to how it was originally

Options: ReplyQuote


Sorry, only registered users may post in this forum.