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]
