nal 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 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] / 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 comp
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
qu
