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"

Reply via email to