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.
Thanks!
--
___ __ __ __ _ _ ____ _ _ ____ ____
/ __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _)
\__ \ )(__)( /(__)\\ / )__) ) ( )__) )(
(___/(______)(__)(__)\/ (____)()(_)\_)(____) (__)
Don't crush that dwarf! Hand me the pliers!
---------------------------------------------------------------------
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
