"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. --------------------------------------------------------------------- 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
