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
fil
der MySQL 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
before
creating the index after 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
: -
To: "Peter J 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
-Original Message-
> From: 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 recor
> 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.
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 pr
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 tab
