Re: Replace delayed locks table

[gerald_clark]

matt ryan wrote:

> 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. 

Replace deletes and inserts.

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