Re: [PHP] More info on timeout problem, with code

2007-11-07 Thread Jochem Maas
Jon Westcot wrote: > Hi Chris: > ... > That is, I need to close the single quote, place a comma after the > field, and then add in another opening quote. One other thing: I suspect I > need to use addslashes() to the elements in $data -- is there a way to do > this with one statement as you

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread Jon Westcot
Hi Chris: > What indexes are on this table? On the import table, there is only one index. And I probably don't even need an index on it since it will be processed sequentially into other tables after it's been imported. > When you do an insert, each one has to update the index > as well as

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread Chris
Jon Westcot wrote: Hi David, et al.: Thanks for the comment. I removed the trailing semi-colon in the two areas where it was being sent to mysql_query() and tried the code again. I'm still getting the same basic problem -- it silently aborts somewhere around 22,000 to 26,000 records being p

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread Daniel Brown
Jon, I can provide you with access to a Linux web box to test your code and database stuff if you'd like. No charge or anything, it's just that I strongly believe the problems are caused by the limits you face with your current web host. If you want to give it a shot, let me know and I'l

RE: [PHP] More info on timeout problem, with code

2007-11-06 Thread Instruct ICC
> Thanks for the comment. I removed the trailing semi-colon in the two > areas where it was being sent to mysql_query() and tried the code again. > I'm still getting the same basic problem -- it silently aborts somewhere > around 22,000 to 26,000 records being processed out of just under 30,000. >

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread Jon Westcot
Hi David, et al.: Thanks for the comment. I removed the trailing semi-colon in the two areas where it was being sent to mysql_query() and tried the code again. I'm still getting the same basic problem -- it silently aborts somewhere around 22,000 to 26,000 records being processed out of just

Re: [PHP] More info on timeout problem, with code

2007-11-06 Thread David Giragosian
On 11/5/07, Jon Westcot <[EMAIL PROTECTED]> wrote: > Hi all: > >As requested, here's the code: > > if(isset($_POST['process'])){ >$old_session_gc_maxlifetime = ""; >$old_max_execution_time = ""; >$old_max_input_time = ""; >$old_session_gc_maxlifetime = ini_set("session.gc_maxl

[PHP] More info on timeout problem, with code

2007-11-05 Thread Jon Westcot
Hi all: As requested, here's the code: Session.gc_maxlifetime: " . ini_get("session.gc_maxlifetime") . "\n"; // shows 1800 echo "Max execution time: " . ini_get("max_execution_time") . "\n"; // shows 1800 echo "Max input time: " . ini_get("max_input_time") . "\n"; // shows -1