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]

Reply via email to