Control How Database Items Are Loaded

Super lets you control how database items are loaded on your site using the Load only the first items of databases setting.

This setting is especially useful for large databases, as it helps prevent too many items from loading at once.

Configure the Database Load Limit in Notion

First, set the number of items you want to display per page in your Notion database.

1. Open the database view in Notion and click ••• (view settings) in its top-right corner.
2. Choose Layout.
3. Find Load limit and pick how many items the view shows (10, 25, 50 or 100).
4. Notion saves the change automatically. Each view has its own load limit.

• When enabled: Databases show only as many items as their Notion load limit (50 for inline databases without a limit). Full-page databases without a limit show everything. The Load More button is not displayed. This speeds up very big databases.
• When disabled: Super displays the initial set of items based on the Notion database load limit and automatically provides a Load More button when additional items are available. Visitors can click the button to load more items.

For example, if your database contains 50 items and the Load Limit in Notion is set to 10:

• Enabled: Only the first 10 items are loaded, with no Load More button.
• Disabled: The first 10 items are displayed, and visitors can click Load More to load additional items.

This allows you to choose between loading only the first page for large databases or letting visitors browse additional items as needed.

You'll find this setting in Settings → Databases → Load only the first items of databases:

Show All Database Items at Once

By default, Super displays database items in batches with a Load More button, allowing visitors to load additional items when needed.

If the Load More button conflicts with your custom code, you can change this behavior to display all database items at once.

How to enable this option

1. Open your Super Dashboard.
2. Open Settings → Databases.
3. Find Show all database items at once.
4. Enable it to display all database items instead of loading them in batches.
5. Save Changes.

When enabled, Super displays all database items at once, and the Load More button is removed.

Note: Loading all items at once may affect performance, especially for databases containing thousands of items. We recommend keeping this option disabled unless the Load More button conflicts with your custom code.

Using nth-child with CSS

If you want to display a specific number of items (less than 10 items) visually, you can also use CSS to hide the remaining items.

For example, if you want to show only the first five items, add the following to Code → CSS:

/* Hide all items after the 5th one */
.notion-collection-gallery .notion-collection-card:nth-child(n+6) {
  display: none !important;
}

How it works

• nth-child(n+6) targets the sixth item onwards.
• Everything after the fifth card will be hidden.
• You can change the number to suit your needs.

Use this approach when you want to control the number of items visible on the page using CSS rather than the database loading settings.