8 messages in com.mysql.lists.mysqlRe: why size of table c united from t...
FromSent OnAttachments
chylli27 Jul 2006 08:12 
Chris27 Jul 2006 18:50 
chylli27 Jul 2006 21:20 
chylli27 Jul 2006 21:30 
chylli27 Jul 2006 21:42 
Chris28 Jul 2006 00:13 
chylli28 Jul 2006 02:31 
Gabriel PREDA30 Jul 2006 01:56 
Subject:Re: why size of table c united from table a and b are bigger than a+b ?
From:chylli (lcyp@gmail.com)
Date:07/27/2006 09:30:02 PM
List:com.mysql.lists.mysql

chylli <lcyp@gmail.com> writes:

Chris <dmag@gmail.com> 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