> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revoengine.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bound reads and show partial results

> Choose pagination, streaming or materialization before a dataset outgrows a view.

An operator view needs a bounded, understandable answer. Choose a limit before loading data and tell the reader when that limit can omit records.

| Need | Use |
| - | - |
| A small operational list | Filter, select required fields and set `take`. |
| Every record in a large dataset | Cursor or paged iteration, or a database export. |
| A large file transfer | Storage-backed streaming. |
| Repeated expensive aggregation | A Materialized View with an explicit refresh policy. |
| One changed dashboard result | Partial refresh with source-side branching. |

## Explore the behavior

Next step

<ol />

Step  of . . .

Illustration only. Select a step to inspect it or return to the start.

## Make the dataset boundary visible

For an orders widget that reads a bounded page, display **Latest 20 matching orders**. Provide a paginated view or a separate export action when an operator needs every match. In a batch processor, use each returned cursor to request the next page before declaring the scan complete.

“Latest 100 runs” is different from “All runs today.” If a query cap can omit records, avoid displaying the count as a complete business total. Include the filter, time window, timezone and completeness in the UI.

Server pagination and browser filtering have different purposes. A Custom Widget TABLE filters the returned data; it does not automatically fetch missing pages. A full export should use the export contract and wait for its completion.

## Keep memory bounded

Select only necessary fields. Process file or database pages incrementally and retain only the state needed for the result. A loop over a single giant in-memory array does not reduce the cost of loading that array.

Use [Database iteration](https://docs.revoengine.com/low-code/database.md#process-large-results), [exports](https://docs.revoengine.com/operate/database-exports.md), [HTTP-to-Storage streaming](https://docs.revoengine.com/low-code/http-storage.md) and [partial widget refresh](https://docs.revoengine.com/widgets/refresh.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.