Ok, so to follow... Paul Dubois told me the little RENAME TABLE trick to swap out a table... Will that work on a table in a MERGE, or are there different hoops to jump through?
On Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote: > "Anthony R. J. Ball" wrote: > > > I was just reading DOCS for MERGE tables... and they > > look like exactly what I want. > > > > I have a large lookup table that I use to track down > > where I want to find my data, which gets loaded into > > different tables at different times of the day > > (financial data). Now I am loading all the data into > > one table, but since this table needs to stay available > > I have to insert into it with lots of keyed data. > > > > I am thinking that I can create a new table, and > > replace the proper underlying table with the new > > data. That way I don't slow doen the lookup table > > when I am loading, and I can load my data MUCH faster > > by loading with no keys. > > > > Am I right in thinking this way. So I can make > > a muni lookup and a CMO lookup and an MBS lookup > > but just select from the merged table for a cusip > > in any of them? > > > > This is all read only data (except the initial load) > > > > This would be very good... since I want the data to > > load quick, and may be loading hundreds of thousands > > of records at a time. > > > > Merge table sound like they fit the bill. Beware that they are very finicky > and the columns MUST be the same and the index order must be the same. > Search the lists (esp. for my name) for more info. > > b. > > -- ___ __ __ __ _ _ ____ _ _ ____ ____ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__) ) ( )__) )( (___/(______)(__)(__)\/ (____)()(_)\_)(____) (__) Once I thought I was wrong - but I was mistaken --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php