Try turning on sql/api logging and watch how many database calls each has. John
----- Original Message ---- From: "Brittain, Mark" <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, April 8, 2008 10:06:09 AM Subject: Performance Question ** 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___ ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
