From: "Jan Hidders" hidders@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