RE: Select most recent record?

From: Mark Hamby [mailto:mark(at)archer(dot)leavenworth(dot)army(dot)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