> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-docs-fix-500-query-results.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Data Settings
> Data grid, pagination, query result cap, JSON viewer, and query history
Browsing a table pages 1,000 rows at a time, and a query that returns more than 10,000 rows stops there. Both numbers, and the rest of what the grid does before you touch anything, are on **Settings > Data**.
The tab is app-wide, so these values apply to every connection you open; filters, column widths, and the sort you clicked are remembered per table instead. Grid fonts are per-theme, on the theme's Fonts tab under [Appearance](/customization/appearance).
## Data Grid
| Setting | Default | Notes |
| --------------------------------- | ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Row height | Normal | Compact, Normal, Comfortable, Spacious |
| Date format | ISO 8601 | ISO 8601, ISO Date, US Long, US Short, EU Long, EU Short |
| NULL display | `NULL` | Text shown for NULL cells, up to 20 characters |
| Show alternate row backgrounds | On | |
| Show row numbers | On | |
| Auto-show inspector on row select | Off | Opens the row details inspector when you select a row |
| Smart value detection | On | Renders UUID, Unix timestamp, JSON, and PHP serialized columns in readable form. Override per column with Display As, see [Data Grid](/features/data-grid) |
| Default row sort | No sorting (engine order) | Or Primary key, First column. Applied when a table first opens; clicking a column header overrides it |
## Pagination
| Setting | Default | Options |
| -------------------------------- | ---------- | ----------------------------------------------- |
| Default page size | 1,000 rows | 100, 500, 1,000, 5,000, 10,000 |
| Count rows if estimate less than | 100,000 | 1,000; 10,000; 100,000; 1,000,000; Always count |
Tables with more estimated rows than the threshold show an approximate count instead of running a slow `COUNT(*)`.
## Query result row cap
| Setting | Default | Options |
| ---------------------- | ------- | --------------------------------------------------- |
| Truncate query results | On | |
| Row cap | 10,000 | 100; 1,000; 5,000; 10,000; 50,000; 100,000; 500,000 |
The cap limits the rows read back, not the statement: your SQL reaches the server exactly as you typed it, and a query carrying its own `LIMIT` is untouched. What a capped result offers instead is in [Query Results](/features/query-results#the-row-cap).
## JSON Viewer
| Setting | Default | Options |
| ------------ | ------- | ---------- |
| Default view | Text | Text, Tree |
Switching modes inside the viewer writes the choice back to this setting. See [JSON Viewer](/features/json-viewer).
## Query History
| Setting | Default | Description |
| -------------------- | ------- | ------------------------------------------------------------------------ |
| **Maximum entries** | 10,000 | 100 to 10,000, or Unlimited |
| **Keep entries for** | 90 days | 7 days to 1 year, or Forever |
| **Auto cleanup** | On | Applies the two limits in this table. Turn it off and nothing is pruned. |
| **Clear History…** | - | Wipe all history, for every connection, after confirmation |
To clear only what you are looking at, use the trash button in the history drawer instead: it respects the drawer's connection scope and date range.