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
