Posted by Andrew @ Rockface on 12/05/05 11:34

Freebird wrote:
> Hello everyone, how are you doing ...
>
> I've a problem in here,
> I need to make a 70 000 rows insert, and it's taking a lot more than 30
> seconds, my problem is that it will be a script that will work in many
> servers, I've no idea of how many, the set_time_limit does not work for
> many of the servers out there, so I'm in trouble, I've tryed to do a refresh
> every 100 inserts, but it doesn't work at all, does anyone have a class,
> function or piece of code that will do that ?
>
> Or help me doing one ? Remembering that set_time_limit will not work for me.
>
> If anybody has something that can help me, send to peoplel@hotmail please,
> tks a lot

How about:
The insert should start at a given row number and end after 100 rows.
The script would then call itself with header() and the number of the
last row inserted + 1.

So the call to the script would be something like
"insert.php?start=<?=$current_row?>&end=100"

--
Andrew @ Rockface
np: (Winamp is not active ;-)
www.rockface-records.co.uk

[Back to original message]