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 started preparing the structure a bit before taking in the data. Seemed to work better in my circumstance.
P -----"Dan Greene" <[EMAIL PROTECTED]> wrote: ----- 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 ( I think in the MySQL docs, might have been here in the list), technically it will take less time to add the indexes after the table creation, than the overhead of index updating per-insert. Either way, it's gonna take a loooooong time. > -----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 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 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 table, filling data and then create indexes? > > > > > > > -- > Best regards, > Krasimir_Slaveykov > mailto: [EMAIL PROTECTED] [EMAIL PROTECTED] > > |-------------------------------------------------| > |///// **** ***** ***** *** **** ***** ** /| > |//// *** *** *** *** *** *** ** *** **** //| > |/// *** *** ***** ***** *** *** ***** *** ///| > |// *** *** *** *** *** *** ** *** *** ////| > |/ **** *** *** *** **** ***** *** /////| > |--------------- www.office1.bg ------------------| > > > -- > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
