Actually...
Run If qualifications (for Filters) do not cause "searches" to the DB.
( Which are the only context that the 'TR' vs 'DB' discussion makes
any sense in.) Run If's (for Filters and Active Links) are evaluated
by the ARS application (server or client) and not sent to the RDBMS.
However, Escalations Run If's are sent to the RDBMS as well as
Set/Push field qualifications.
Yes.. Yes... if you reference 'Field' or 'DB.Field' in a Filter Run If
then the record of interest for the transaction is fetched from the
DB. But that is based on 'Entry ID' (Field 1) and is the unique
clustered index on the form so that search is mute. It is the best
that the DB can do and the value of having the DB values at had
generally far out ways the cost of that trip to the RDMBS. (IMHO)
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On Fri, Feb 22, 2008 at 10:15 AM, McCabe, Richard A. (CMS/CTR)
<[EMAIL PROTECTED]> wrote:
> **
>
>
>
> The following statements would fire the same, but the first statement would
> be cleaner to read, and more efficient as it would not cause a full query of
> the table by causing the database to run a "not equal to" search bypassing
> your indexes. ( 'TR.lesson_status' = "Completed") vs. ('DB.lesson_status' !=
> "Completed" AND 'lesson_status' = "Completed")
>
>
>
> Richard McCabe
>
>
>
>
> ________________________________
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
> Sent: Thursday, February 21, 2008 6:51 PM
>
>
> To: [email protected]
> Subject: Re: Interview questions
>
>
>
>
>
> So what's wrong with
>
>
>
> AND ( 'lesson_status' = "Completed" ) AND ( 'DB.lesson_status' !=
> "Completed" )
>
>
>
> When do you expect that to fire when you don't want it to??
>
>
>
>
> David Sanders
>
> Remedy Solution Architect
>
> Enterprise Service Suite @ Work
>
> ==========================
>
> ARS List Award Winner 2005
>
> Best 3rd party Remedy Application
>
>
>
> See the ESS Concepts Guide
>
> tel +44 1494 468980
> mobile +44 7710 377761
> email [EMAIL PROTECTED]
> web http://www.westoverconsulting.co.uk
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
