Re: Quick Check under Time On Tab
Dale E. Reed Jr. ( (no email) )
Sun, 13 Apr 1997 03:46:08 -0700
Grant McClure wrote:
>
> Does anyone know what it does exactly?
>
> I've trapped the SQL and isolated the difference in the select statement run against the calls table.
>
> If Quick Check is off, it selects
> Start=DateAdd(Second, 0-AcctSessionTime, CallDate)
>
> If Quick Check is on, it selects:
> Start=DateAdd(Second, (0-AcctSessionTime-AcctDelayTime), CallDate)
It doesn't take the AcctDelayTime field into consideration, therfore it
can be
faster, BUT in-accurate. AcctDelayTime is not indexed, that is the main
reason.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com