How do you suppose Remedy gets data from the db? Sql menus have less overhead (see caveats below) because they bypass a lot of checks and extra data that the remedy api imposes:
These api calls (I'm assuming) are used by search menus to retrieve data: * gle - get list entry * glewf - get list entry with fields Some info on these api calls: - calls to gle/glewf 'may' retrieve data from both the T and H tables - calls to gle/glewf observes field permissions (row level permissions implied) - calls to gle/glewf observes form permissions It would be easy to get a definitive answer to this for yourself by creating both menus and capturing the sql and api logs then comparing. Probably the only way you would pick up some benefit using a search menu would be by using one of the 'Refresh On' options in the menu definition that would cause the client to cache the results for re-use. Axton Grams On Tue, Apr 8, 2008 at 10:06 AM, Brittain, Mark <[EMAIL PROTECTED]> wrote: > ** > > HI All, > > We have a great debate going on here about performance of menus where data > is stored on a Remedy form. So which do you think is better? Search or SQL > ? > > Search Example on the Group Form - ( 'Status' = "Current") AND ( 'Group > ID' >= 902) AND ( 'Group ID' < 1000) > > SQL Example for the same select group_name from group_x where group_type = > '2' and group_id between 900 and 999 order by group_name > > My thought is the Search is better because you don't have to pass from the > Remedy Server, to the Oracle Client to get to the Oracle server. > > Your opinion is highly valued. > > Thanks > > Mark > > Mark Brittain > > ESM Remedy Developer > > Navisite Inc. > > *This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that > is privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited.* > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"