>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]