Fixing my brain farts :-(
> Run your "current status" queries against the "current" table while if
> 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
Again, I meant to delete the old records from the Current table, not the
My apologies to the list!
Unimin Corporation - Spruce Pine