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 the database if you want to confirm that. I am not sure what the AR server does with it. I would suspect (hope) that it retrieves the entire result set and then sends the client only the top xxxx. Juan Ingles On Thu, Apr 22, 2010 at 3:16 AM, Kali Obsum <[email protected]> wrote: > ** > 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 User Tool? Or will the limit > already be incorporated in the query such that only the top N results will > be queried? > > Regards, > Kali > > > NOTICE > > The information contained in this email is confidential. If you are not the > intended recipient, you must not disclose or use the information in this > email in any way. If you received it in error, please tell us immediately by > return email and delete the document. We do not guarantee the integrity of > any e-mails or attached files and are not responsible for any changes made > to them by any other person. > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

