Fixing my brain farts :-(
<snip>
> Run your "current status" queries against the "current" table while if
you
> want in-depth history of a particular flight, use the "history" table.
> This will increase your responsiveness considerably as there should be
> only 1 record per active flight in that table.
I meant to say one record per flight in the Curent table.
>
> There are several ways to approach this:
>
> a) INSERT everything into the history table then on a periodic basis,
> regenerate the Current table.
> b) INSERT records into both tables and DELETE the old one from the
history
> table.
Again, I meant to delete the old records from the Current table, not the
history table.
My apologies to the list!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
