# [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
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
Message-
From: Amit Lonkar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 9:33 PM
To: [EMAIL PROTECTED]
Subject: Query Execution Time in mysql
Hi All,
I have 2 tables say table1 and table2 in the
database. I am using the following query to copy all
the data from table2
Hi All,
I have 2 tables say table1 and table2 in the
database. I am using the following query to copy all
the data from table2 to table1.
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