I think we need more info: Table definition, MySQL version etc.. Med venlig hilsen Lars Geisler
> > -----Original Message----- > From: "Roman Neuhauser" <[EMAIL PROTECTED]> > To: "Amit Lonkar" <[EMAIL PROTECTED]> > CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: Re: Query Execution Time in mysql > Sent: on, 25 jun 2003 12:36:34 GMT > Received: on, 25 jun 2003 12:40:14 GMT > Read: on, 25 jun 2003 13:19:51 GMT > # [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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]