chylli <[EMAIL PROTECTED]> writes: > Chris <[EMAIL PROTECTED]> writes: > >> >> Because you're adding all columns from a and b into it. >> >>> It is too slow. Has anyone better methods to do that work? >> >> Drop the indexes on c and create them at the end. >> Each row that's being added, it's updating the index at the same time, >> so that will be your bottleneck. >> will adding index last after inserting take also VERY LONG time ? Hope it won't.
-- Thanks & Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
