From: Mark Hamby [mailto:mark@archer.leavenworth.army.mil]
>
> Marc,
> Did you ever get your problem solved to your satisfaction?
> We have a very simular problem with a historical database
> containing typically 5K id and updates to data every few
> seconds. We tried unsuccessfully to optimize queries
> such as those already suggested to you. We found the best
> means to quickly query the data valid at any given time was
> to:
[snip]
By adding an index, I was able to get the performance of the
query within a reasonable threshold; it's still slow, but
acceptable. I'll bear your suggestion in mind for next time
I run into this kind of problem, though, if my sol'n can't
handle the data. Thanks,
- Marc