**Source URL:** https://limited.veevavault.dev/medical/vql/clauses/pagesize

# PAGESIZE

By default, the maximum number of results displayed per page is 200 for documents and 1000 for objects. In v20.3+, use the `PAGESIZE` clause to limit the number of results returned per page.

Using `PAGESIZE` does not change the total number of results found, only the number displayed per page.

Learn more about [limiting page results](/medical/vql/references/system-limits-performance/page-size-specifications).

If you’re using VQL version v20.2 or lower, you must use `LIMIT` instead of `PAGESIZE`. If you use both `LIMIT` and `PAGESIZE` in a query, the query ignores `LIMIT`.

<Aside type="note">
Vault may [scale down the page size](/medical/vql/references/system-limits-performance/page-size-specifications) to protect performance.
</Aside>

## Syntax

```sql
SELECT {fields}
FROM {query target}
PAGESIZE {number}
```

## Query Examples

The following are examples of queries using `PAGESIZE`.

### Query

The following query returns 25 documents per page:

```sql
SELECT id
FROM documents
PAGESIZE 25
```

## LIMIT

<Aside type="note">
Deprecated as of v20.3. Instead, use [`PAGESIZE`](/medical/vql/clauses/pagesize).
</Aside>

By default, the maximum number of results displayed per page is 200 for documents and 1000 for objects. Use the `LIMIT` clause to limit the number of results returned per page.

Using `LIMIT` does not change the total number of results found, only the number displayed per page.

Learn more about [limiting page results](/medical/vql/references/system-limits-performance/page-size-specifications).

### Syntax

```sql
SELECT {fields}
FROM {query target}
LIMIT {number}
```

### Query Examples

The following are examples of queries using `LIMIT`.

#### Query

The following query returns 25 documents per page:

```sql
SELECT id
FROM documents
LIMIT 25
```

---

**Previous:** [SKIP](/medical/vql/clauses/skip)  
**Next:** [PAGEOFFSET](/medical/vql/clauses/pageoffset)