The 'Field' != $VALUE$ he is referring to have to do with ENUM fields, and that does do a table scan, because it grabs all records and then disregards the != $VALUE$. It's better to do a <> on those fields. We have some pretty hefty systems here, and a few of the != searches can hurt us if they are done right after each other. One could make their own Advanced Search bar, disable Remedy's, and build in logic to avoid doing those kinds of search on certain fields. It won't fix everything, but it will help.
Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Monday, April 07, 2008 15:00 To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Bar I hate to be Mr. Obvious! It seems to me that attempting to disable advanced searches is an act of desperation. If you're so concerned about users running advanced searches and eating up too much system resources, perhaps either your system needs a major upgrade or it's not tuned very well. We have a single Remedy server here (and a separate Midtier)...Dell 2860 with 4GB RAM. It supports 18,000+ users 24/7 and it runs like a champ. I would never dream of disabling the query bar...if performance were an issue, I'd look elsewhere... -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, April 07, 2008 2:16 PM To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Bar Nothing of course, but it would prevent searches like 'Field' != "value" which if memory serves, ignores indexes. Assuming it can be done anyway. Michael A. McManus, SSgt, USAF -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Monday, April 07, 2008 1:45 PM To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Bar ** If you did that, then what would stop them from keying values in the fields themselves? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754 ELSG/DOMH Sent: Monday, April 07, 2008 13:42 To: arslist@ARSLIST.ORG Subject: Advanced Search Bar ** Dear listers, It's been some time since anyone on my project has been to the performance and tuning class and we're having some performance issues at peak times. I'm sure we're getting killed in multiple areas (QBE settings, Indexing, etc.) but one of the questions I was asked is about the Advanced Search Bar. I did a quick scan of the docset and didn't see an answer. Is there any way to prevent users from using the Advanced bar? I see a menu for "Search Bar" in the form action fields, but it's not checked on any of our forms. Thanks much, Michael A. McManus, SSgt, USAF __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** __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" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
