Hello ,
I must create a temp table with 5 or more million records.
I need it for creating some reports, so I need to create indexes too.
My question is:
When total time for work will be smaller? :
1-st case: I create table and create indexes immediately before
filling data.
2-nd case: I create
I'd start with the indexes in place. 5+mil records will take quite some
time to index after the fact.
P
-Krasimir_Slaveykov [EMAIL PROTECTED] wrote: -
To: [EMAIL PROTECTED]
From: Krasimir_Slaveykov [EMAIL PROTECTED]
Date: 01/30/2004 09:14AM
Subject: SQL and productivity
Hello ,
I
When total time for work will be smaller? :
1-st case: I create table and create indexes immediately before
filling data.
2-nd case: I create table, filling data and then create indexes?
Filling the data data first and creating indexes after is faster, so you
should definitly go with nr 2.
: Peter J Milanese [mailto:[EMAIL PROTECTED]
Sent: Friday, January 30, 2004 9:15 AM
To: Krasimir_Slaveykov
Cc: [EMAIL PROTECTED]
Subject: Re: SQL and productivity
I'd start with the indexes in place. 5+mil records will take
quite some
time to index after the fact.
P
Milanese [EMAIL PROTECTED], Krasimir_Slaveykov
[EMAIL PROTECTED]
From: Dan Greene [EMAIL PROTECTED]
Date: 01/30/2004 09:31AM
cc: [EMAIL PROTECTED]
Subject: RE: SQL and productivity
From what I've read ( I think in the MySQL docs, might have been here in
the list), technically it will take less time
load. If that's the case it would probably cost
you more time.
Ed
-Original Message-
From: Peter J Milanese [mailto:[EMAIL PROTECTED]
Subject: RE: SQL and productivity
Heh..
I wasn't going by the docs when I responded... I had to reindex a 50+mil
row table... Not a good time :) Then I
technical support from https://order.mysql.com/
Best regards,
Mikhail.
- Original Message -
From: Krasimir_Slaveykov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 30, 2004 3:14 PM
Subject: SQL and productivity
Hello ,
I must create
At 08:14 AM 1/30/2004, you wrote:
Hello ,
I must create a temp table with 5 or more million records.
I need it for creating some reports, so I need to create indexes too.
My question is:
When total time for work will be smaller? :
1-st case: I create table and create indexes immediately before