To reduce the memory footprint of ACT and other Aster Database clients, you can set a fetch-count that constrains the number of rows returned at one time when you select from a large table. You can limit the total number of rows returned by using fetch-limit. Additionally, you can make your query results stream more efficiently by using the server-side cursors feature. In ACT, you can set these parameters using \set, and in other clients you can typically set them in your data source definition or parameters file.
Let’s look at fetch-count first.