---
title: How to limit search results on Web.Instance.Search
slug: how-to-limit-search-results-on-webinstancesearch
createdAt: 2025-06-11T20:26:20.404Z
---

When managing asset instances, it is possible to encounter tens of thousands of rows. As the number of rows increases, the load time on instance pages in Activate may be adversely affected. To mitigate this, consider reducing the initial load to the first 100 rows. This can be achieved in Activate by adding the TOP clause to the query in the Web.Instance.Search parameter.

## Steps

1. Open the Web.Instance.Search parameter in text mode
2. Modify the query node of the Web.Form and add top 100 as the first clause in the query

Each query returned will now only return the top 100 results. It's also possible to add a control to make the desired row count selectable, an example of how to achieve this is attached.