> hmm if you were running PostGreSQL ;p yer, but....... I'm not (stop giggling please).
> but if you want it updated > regularly you might be best to create a scheduled task that does what > you're describing - select from each table and insert into the new > one. I guess what I want to know is: is it quicker to SELECT INTO FILE and the do INSERTS back and forth between the tables or just get the master up to date and then drop everything else & recreate it. I guess I just need to test. Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.com --- 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/
