Reducing the number of rows returned in queries
You can choose to retrieve all rows or any specified maximum number of
rows in queries. This option overrides the system default limit that is set on queries that
return data records and items in drop-down lists. However, unlimited queries can degrade
system performance or exceed the resources of the application server and the client machine.
Regardless of the option you select, record retrieval is subject to any system-wide record cap overrides that might be in effect. See the help topic "About caps".