'Field' will not cause a read from the db, only 'DB.Field'. All the current transaction values are already available on the Remedy side, how else would Remedy know what to write to the db?
Axton On 10/4/07, Misi Mladoniczky <[EMAIL PROTECTED]> wrote: > Hi, > > Just remember that 'DB.Field' and 'Field' both results in an fetch from > the database. How else can the 'Field' (most current) be computed! > > Another issue to concider is that if any Filter-Set-Fields on CURRENT > TRANSACTION are referencing fields, e.g. $Field$, the complete record is > also fetched from the databas. > > My point is that it is very rare to have a form with: > 1. Filter run-ifs with only references to TR-values only > 2. No filter actions triggered that reference fields, where database > values may be required > > If any of the above things are true, the complete set of fields will be > retrieved. > > Best Regards - Misi, RRR AB, http://www.rrr.se/sv/ > > > That was my understanding of DB.field also. > > > > > > > > I haven't taken the Performance Tuning class. Does the class cover what > > the difference is between TR and DB and when to use either one? > > > > > > > > DB may be an efficient search but still a search where as TR would not be > > a search, correct? Even searching by the known record number in a really > > large table still could take some time. Multiply that by tens of thousands > > of records in the import scenario and it really starts adding up. > > > > > > > > Jason > > > > > > > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David > > Sent: Wednesday, October 03, 2007 9:09 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: Filter Problem > > > > > > > > DB.Field has to query the database. By definition it is the data that's > > stored in the field in the database. > > > >>From my Performance Tuning class several years ago, Lincoln noted that it > >> was an efficient search because the record number is already known. > > > > Dave > > -------------------------- > > [EMAIL PROTECTED] (Wireless) > > > > ----- Original Message ----- > > From: Action Request System discussion list(ARSList) > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
