On SQL7, 600K records can be processed in 20 minutes.
Duane.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Ronnie Franklin
Sent: Thursday, December 02, 1999 6:46 PM
To: emerald@iea-software.com
Subject: RE: [Emerald] Call Consolidation
Move to SQL 7.0 and it will finish in 1/10 the time....
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Emerald
> Sent: Thursday, December 02, 1999 6:05 PM
> To: emerald@iea-software.com
> Subject: [Emerald] Call Consolidation
>
>
> Dale,
>
> 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.
>
> Geo.
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart