---
title: "Subquery limits"
canonical: "https://support.appfire.com/space/JQLSEARCH/604209716/Subquery%20limits"
format: markdown
---
> Macro (aura-html)

## What is a subquery limit?

Some JQL Search Extensions functions allow you to specify a subquery JQL, for example, <span style="color: #091e42"> </span>`allIssuesInEpic` function<span style="color: #091e42">. This subquery function can be matched anywhere from 0 to all issues of your instance, which, in very large instances, could cause some trouble. To protect your Jira instance from outages, extensive CPU or memory usage, or simply overloading the Jira Lucene index, JQL subquery-based functions are protected with a limit. By default, this limit is configured to 10,000 issues, however, instances running on strong server machines can process more than 10,000 issues without trouble. A Jira administrator can raise the limit if needed. To learn more about the impact this limit has on JQL execution, see our </span><span style="color: #091e42">[performance test results](https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209740)</span><span style="color: #091e42"> page.</span>

## <span style="color: #091e42">Functions affected by the subquery limit</span>

- <span style="color: #091e42">allIssuesInEpic</span>
- <span style="color: #091e42">epicOf</span>
- <span style="color: #091e42">fieldMatch</span>
- <span style="color: #091e42">fieldsHaveSameValue</span>
- <span style="color: #091e42">parentOf</span>
- <span style="color: #091e42">subtaskOf</span>
- <span style="color: #091e42">links</span>
- <span style="color: #091e42">linkedBy</span>

## <span style="color: #091e42">How to raise the limit</span>

<span style="color: #091e42">The subquery limit can be raised by specifying a system property called </span>*com.digitaltoucan.jqlextensions.subquery.limit*<span style="color: #091e42">. For example, to raise the limit to 30,000 you need to configure a system property to:</span>

```
-Dcom.digitaltoucan.jqlextensions.subquery.limit=30000
```

To learn how to set a system property on a Jira instance, refer to Atlassian’s Jira documentation page [https://confluence.atlassian.com/adminjiraserver/setting-properties-and-options-on-startup-938847831.html](https://confluence.atlassian.com/adminjiraserver/setting-properties-and-options-on-startup-938847831.html)