From: "Jan Hidders" <hidders(a)uia.ua.ac.be>
Oh dear. Sorry that my instructions were not clear. You are supposed to
run
the script, wait for a link to appear and then click
this link for the
next
batch. It seems you did only one batch. You need to
repeat this until all
the records in table cur have been processed. This means you have to click
about 37 or 38 times, or you have to increase $size to do bigger batches.
(But avoid the 30 s. time-out. If you get a time-out you have the clear
the
table "DELETE FROM linked WHERE 1=1;" and
start from the beginning again.)
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.
-- Jan Hidders