--- Alberto Simões <[EMAIL PROTECTED]> wrote: > The tables are related but they are already being created in parallel > (three tables). I was joining them just because it was easier to move. > But given the new, erm, big size, I think I'll maintain them split. > > Joe Wilson idea of attaching the tables seems cool. I'll give it a try.
If you're creating the 3 databases in parallel, you would be better off creating 3 connections (each from a seperate thread or process) to populate them in order to more efficiently use the spare cycles of the CPU during I/O waits. Use ATTACH from one connection after the databases have been populated to read from all of them. ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
