On Mar 15, 2008, at 2:36 PM, Roger Deschner wrote:

That occupancy table can be REALLY slow to process if your system
is at
all large. I prefer to search the summary table which is fast, even
with
my 275gb database.

Roger - Are you thinking of the Contents table?

I have a large system, and it takes about 3 seconds to get results
from that Select of the Occupancy table.  It takes about 20 times
longer to go through the Summary table, where the retention is 30 days.

   Richard Sims