Rod,

>FWIW, the SQL Select command based on a key value will perform as fast as a seek command.
>Take a look at foxforum.com

I have a real trouble believing this when knowing how this is implemented. Fact is that in any SQL server database the external scheme is seperated from its implementation. The seek is a very effictive command by directly using the index without relying on an optimizer and its overhead.

>Click on the last 3, 7 or 30 days option. It's actually calling this for each topic that comes up

I will do a test myself when I´ve got the time and report it up here.

Walter