Our calls table is huge with 1801136
records showing on select count(*) from calls
The summary shows 13 periods to consolidate. However, about 30 hours
only 15k records were done. Is this typical? At that rate we would
never finish consolidating. The SQL server runs on a P2-450, 512MB
RAM, RAID5 UW SCSI Array.
It seemed to have messed something up after the emerald client was
killed...we cannot email invoices out now...it returns an error.
At this point I am about willing to dump call records in the call
table and start fresh consolidating every week to keep it low.
Dale how long do you think it would take to run a
delete * from calls with that many records? Will it mess anything up?
Should anything be done like radius stopped before it is run?
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html