Hi Mark, well failing the porting of the application to a real database ;p (only kidding) I think you're probably better off yanking everything from your disparate datasources, appending to a big query object and just inserting into the master, via a script. I'm not sure what mysql's select into file performance is like but I don't think either method is going to be monumentally faster or slower than the other... Would be interested to hear the results though if you go ahead and test both.
cheers, Toby Friday, February 7, 2003, 12:13:49 PM, you wrote: >> This is where a VIEW would come in handy MS> Yes yes don't rub it in. MS> Cheers MS> Mark MS> ______________ MS> Mark Stanton MS> Web Production MS> Gruden Pty Ltd MS> Tel: 9956 6388 MS> Mob: 0410 458 201 MS> Fax: 9956 8433 MS> www.gruden.com MS> --- MS> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] MS> To unsubscribe send a blank email to [EMAIL PROTECTED] MS> MX Downunder AsiaPac DevCon - http://mxdu.com/ --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
