# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700:
> insert into table1 select * from table2;
> 
> Table2 has some 10,000 records while table1 has around
> 11,00,000 records. The time reqd. to execute the above
> query is round about 80- 90 secs. 
> 
> The table1 has 7 columns out of which 5 are composite
> primary keys. No other indexing is provided. I have
> also tried to use the "optimize table table1" command
> but to no effect.

    does this help?

    http://www.mysql.com/doc/en/Insert_speed.html

-- 
If you cc me or remove the list(s) completely I'll most likely ignore
your message.    see http://www.eyrie.org./~eagle/faqs/questions.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to