I"m not an SQL type, but I've been looking at the call consolidation
routine. Correct me if I'm wrong but does this thing go thru the whole calls
table for each customer?
Wouldn't it be a lot faster to go thru the calls table once, create an index
or something for how it needs to be done, then go thru it a second time to
do the work instead of this way?
I've got a 1.4 million record calls table, this thing is running on a
PIII-600 with half a gig of ram and it's taking 2 days to complete. This is
nuts, I've got the equivalent of a 1980 mainframe here and it's taking days.
Something is definitely not right with the way the call consolidation does
it's thing. It's repeatedly going thru the whole table for some reason, over
and over again.
For more information about this list (including removal) go to: