Re: [PHP-DB] How to stop the server timing out
Hi, when you say the 'server' times out, do you mean the script reaches it's execution limit (usually around 60 seconds). If that is the case and you have no control over the PHP environment, then there is little you can do to help. The only thing you can do in this situation is to improve the efficiency of your SQL statement (or the db's structure) so it can execute and return faster. But if you're processing a lot of data that may not be enough Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] How to stop the server timing out
You need to just start adding echo statements to the code to see where the hang up is Bastien From: "David Skyers" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or speed up how the page works. Please note I do not have any control over the server. The page does a select from a table and inserts the data into another table. However it times-out half way through inserting. The code is attached. Thanks, David David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849 Email: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to stop the server timing out
hmm, you can edit your php.ini there is max_execution_time or in header of your php file put *ini_set* ( "max_execution_time", string newvalue ) Bastien Koert napisaĆ(a): You need to just start adding echo statements to the code to see where the hang up is Bastien From: "David Skyers" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or speed up how the page works. Please note I do not have any control over the server. The page does a select from a table and inserts the data into another table. However it times-out half way through inserting. The code is attached. Thanks, David David Skyers Support Analyst Management Systems, EISD, UCL Extension: 41849 Tel: 020 7679 1849 Email: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Pozdrawiam Szymon Fornal Bild Presse Polska s.c. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- e-mail: [EMAIL PROTECTED] GG: 1234713 ICQ: 208408766 mobile: (+48) 504049222 work: (+48) 042 6362632 w. 18 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to stop the server timing out
Hi, > Is there anything I can do, to get the page to run completely sure, contact the hosting company to prolong the maximum execution time on that script > or speed up how the page works maybe, but I dont see the source code > The page does a select from a table and inserts the data into another table do you use insert ... select syntax? OKi98 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] How to stop the server timing out
Hi, Thanks, the echos causes the page to responds after each insert, so the server no longer times out. David -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 04 October 2006 03:24 To: David Skyers; php-db@lists.php.net Subject: RE: [PHP-DB] How to stop the server timing out You need to just start adding echo statements to the code to see where the hang up is Bastien >From: "David Skyers" <[EMAIL PROTECTED]> >To: >Subject: [PHP-DB] How to stop the server timing out >Date: Tue, 3 Oct 2006 11:51:30 +0100 > >Hi, > >I have written a php page and every time I run it, it causes the server >to times-out. Is there anything I can do, to get the page to run >completely or speed up how the page works. Please note I do not have >any control over the server. > >The page does a select from a table and inserts the data into another >table. However it times-out half way through inserting. > >The code is attached. > >Thanks, > >David > > >David Skyers >Support Analyst >Management Systems, EISD, UCL >Extension: 41849 >Tel: 020 7679 1849 >Email: [EMAIL PROTECTED] > > >-- >PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: >http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php