chylli wrote:
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.
Yes, but it will be quicker than it is now which has to update the index
with every new row added to table 'c'.
I think you could also just do:
ALTER TABLE c DISABLE KEYS;
insert into c.....
ALTER TABLE c ENABLE KEYS;
which does exactly the same thing but means you don't have to remember
which indexes you had ;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
