> 2) Our call history consolidation works (and has always worked) very quickly. We have 1000MBR's and still, weekly consolidation takes only 5 minutes or so. GREAT!!!!! But when we check to see how much time a user has used during the last month, it takes over a minute for the information to appear on the screen on the TimeOn tab. Is there something I can do to make the TimeOn function work more quickly?
Check your indexes on the Calls table, particularly the Username,
CallDate and AcctStatusType fields. If those indexes are out of
date or don't exist, the lookups will be slow.
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com