Re: Looking for ways to prevent timeout

Hi Nathan: No, I'm not familiar with Ajax. Where can I read up on it? More important, how can I find out if Ajax is implemented on the server? Or is it something I can add myself? Thanks again, Jon ----- Original Message ----- From: "Nathan Nobbe" <quickshiftin@gmail.com> To: "Jon Westcot" <jon@westcot.net> Cc: "PHP General" <php-general@lists.php.net> Sent: Sunday, November 04, 2007 7:53 PM Subject: Re: [PHP] Looking for ways to prevent timeout > On 11/4/07, Jon Westcot <jon@westcot.net> wrote: > > > > Hi all: > > > > I'm hoping to find a solution to the problem I'm having with my script > > timing out while inserting records into a table. > > > > Overall, the process is pretty fast, which is impressive, but when it > > gets to the 22,000 to 23,000 record mark, it seems to time out. I've had it > > get up over 26,000 so far, but nothing better than that. And I only need to > > process around 30,000 right now. > > > > I've tried setting max_execution_time to 1800; no improvement. The > > value for max_input_time is -1, which, if I understood it correcctly, is the > > same as saying no limit. And I've tried calling set_time_limit() with both > > 0 and with 360, none of which seemed to help. > > > > Is there ANY WAY to increase the amount of time I can use when running > > a script that will work? I've tried everything I can find in the PHP > > manual. > > > > Any help you can provide will be greatly appreciated! > > > are you familiar with ajax ? > i would build some client side tool that would split the job into a series > of requests. > say, you input 20,000; then the script fires off 5 requests, to do 4000 > inserts a piece. > you could easily implement a status bar and it would be guaranteed to work. > also, it would scale just about as high as you can imagine. > > -nathan >