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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
