Re: Search Results Returned Limit

2010-04-23 Thread Atul Vohra
@ARSLIST.ORG Subject: Search Results Returned Limit ** In the Remedy User Tool, there is an option to limit the number of search results to be returned. How does this work in the DB level? Does it mean that if the query performed produces 10,000 results, the DB will still search for those 10,000

Re: Search Results Returned Limit

2010-04-23 Thread Nichols, Wesley
: Search Results Returned Limit Is there a way to limit the query results server-wide i.e. not controlled by the client - may be a parameter in ar.cfg file? v7.1 Thanks Atul Vohra -Original Message- From: Mueller, Doug [doug_muel...@bmc.com] Date: 04/22/2010 03:56 PM To: arslist@ARSLIST.ORG

Search Results Returned Limit

2010-04-22 Thread Kali Obsum
In the Remedy User Tool, there is an option to limit the number of search results to be returned. How does this work in the DB level? Does it mean that if the query performed produces 10,000 results, the DB will still search for those 10,000 but only a limited number will get displayed in the

Re: Search Results Returned Limit

2010-04-22 Thread Juan Ingles
Kali, I haven't double checked with recent versions, but in the past it only limited what was displayed and not what was actually queried. I really don't expect that to ever change since the database has to query the whole set if there is a sort. The SQL log will show the query as it is sent to

Re: Search Results Returned Limit

2010-04-22 Thread Guillaume Rheault
To: arslist@ARSLIST.ORG Subject: Search Results Returned Limit ** In the Remedy User Tool, there is an option to limit the number of search results to be returned. How does this work in the DB level? Does it mean that if the query performed produces 10,000 results, the DB will still search for those

Re: Search Results Returned Limit

2010-04-22 Thread Mueller, Doug
Results Returned Limit ** In the Remedy User Tool, there is an option to limit the number of search results to be returned. How does this work in the DB level? Does it mean that if the query performed produces 10,000 results, the DB will still search for those 10,000 but only a limited number