Replace delayed locks table

[matt ryan]

SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from 
temp table.


This takes 2 hours to comlete, the temp table is rather large.

The table being updated is locked, the whole time, all web requests are 
locked and the pages time out.

Is there any way to get this to run without locking the whole table?  I 
thought with myisam it would only lock a table if you delete records, 
and insert records, it locks it to fill the gaps.

If I need to switch to another table type it's an option, having locked 
tables is NOT an option.


Thanks in advance Matt