nielsena54
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by nielsena54
-
-
Hey all,
I am writing PHP scripts to do some data transfer. One of the tables that I am importing is 400000+ records long. My challenge is avoiding the CGI timeout error in IIS. After 5 minutes it displays, no matter what I do.
I have already used MetaBase to change the default value to a high number (24 hrs, or 86400 seconds). I have also changed the property in the IIS Manager GUI to reflect this change. I have restarted the server and the computer multiple times, but to no avail.
I would just switch to Apache, except that I am transferring data into Microsoft SQL on a Microsoft Server running IIS .Net web services.
The exact error reads:
"CGI Timeout
The specified CGI application exceeded the allowed time for processing. The server has deleted the process."
Thanks in advance!
CGI Timeout on IIS driving me nuts! Can't get it to leave -- help appreciated.
in PHP Coding Help
Posted
I wouldn't attempt to import that many recs through a web script. Do it off-line.
What are you importing to and from - there may be a quicker method?
[/quote]
I am importing from Dataflex using an ODBC driver. I am doing it offline in the sense that it is on an intranet, definitely not a public script. This is the most efficient method that I have found so far; any other transfer options cost a whole lot of money because of the unique nature of DataFlex.
As I'm writing this, I am realizing that I could maybe use Access with the same ODBC driver.... and make something work that way....
Anyway, I am still curious as to how to get rid of this cgi timeout error. In the meantime, I will either use a local Apache server on the same network or try some Access methods.
thanks!