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