What we did to get around this issue is only allowed it on one of our servers, server group of 4 with 3 out of 4 on the load balancer. That way the people that need the ability to do the searches can, by directly connecting to that server and the "normal" users are not affected if there are any performance issues. You could also set the "Max entries Returned" to something that would be appropriate for the searches required but will still prevent any performance hits.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, August 08, 2012 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: unqualified searches ** You may see performance hits if some one creates a malformed search that returns every record that was created in the table. For tables with not much data no problem. If you've been using the ITSM Suite for some time, it may be an issue. Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hodgdon, Paul Sent: Wednesday, August 08, 2012 2:54 PM To: arslist@ARSLIST.ORG Subject: unqualified searches ** Is there any harm in allowing unqualified searches in a production environment. We had been told that we should disallow this for production, but we are finding that in order to leverage some of the reporting capabilities (dynamically choosing parameters such as groups) this option is prohibiting this. In essence this really isn't doing much as a user can do a search where incident number is not null. -Paul IT Accounts & Remedy Administration Manager University of New Hampshire Client Services Primary: (603) 862-2377 Alternate: (603) 862-4242 paul.hodg...@unh.edu<mailto:paul.hodg...@unh.edu> http://accounts.unh.edu<http://accounts.unh.edu/> The information transmitted in this e-mail, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential/privileged material. Any review, retransmission, dissemination, taking any action or other use thereof, by anyone other than the intended recipient, is prohibited. Responses to this e-mail must not include any restricted or sensitive information. If you received this in error, please contact the sender and destroy any copies of this message, including any attachments. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"