On mer, 2002-02-27 at 02:42, Jan Hidders wrote:
Because you already did a batch you need to empty the
tables first. The
fastest way to do this is simply to drop the tables altogether. After that
you can recreate them without the indexes (as in updSchema.sql) and fill
them with the script. Considering the speed of your system you might simply
try setting $size to 40000 or so, and attempt to do everything in one go. If
that times-out, clear the tables 'linked' and 'unlinked' with DELETE
and
try again with half the value. Et cetera. After this you can add the indexes
as in updSchema.sql.
You can also set set_time_limit(9999) or some such. No nasty timeouts!
-- brion vibber (brion @
pobox.com)