What we found was on an Oracle server is that it would get all the rows of the query and then return the first X in the list limit. This really didn't resolve the issue on the server side. After moving to MSSQL and looking at the SQL that ARServer generates, it uses the TOP statement with the list limit, so this is limited on the database and those extraneous rows are never sent to the AR server.
We have two AR servers, one is used for user connections, the other is for AIE\CMDB\Bulk Updates. For the user facing server we allow unqualified searches, but limit the rows to 3000. This has proven to be a suitable middle ground and we haven't had much of an issue with poorly formed queries. The other backend type server, we don't limit it in either regard. Jim Coryat Senior Software Engineer Micron Technology Inc. From: Saji Philip [mailto:[email protected]] Sent: Wednesday, August 29, 2012 6:07 PM Subject: Re: unqualified searches ** Hello Paul, There are ways around the "unqualified search" issues as you hit upon. Personally, in our org we found unqualified searches caused degradation in our performance and at times locking up the mid-tier. To solve our problem our admin has put in a get list limit. But we also have disallowed unqualified searches. On Aug 8, 2012 1:54 PM, "Hodgdon, Paul" <[email protected]<mailto:[email protected]>> wrote: ** 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<tel:%28603%29%20862-2377> Alternate: (603) 862-4242<tel:%28603%29%20862-4242> [email protected]<mailto:[email protected]> 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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
