# Atlassian reports Jira query preparation fell from 18 seconds to 92 milliseconds

_Published Wednesday, November 11, 2026 at 3:33 AM EST · Products, Infrastructure · Latest · Tier 2 — Notable_

![Atlassian reports Jira query preparation fell from 18 seconds to 92 milliseconds — Primary](https://atlassianblog.wpengine.com/wp-content/uploads/2026/11/image-20261028-120816.webp)

Atlassian says changes to Jira's handling of software release versions reduced P99 query resolution time for project-scoped searches from around 18 seconds to 92 milliseconds. Query resolution prepares names and functions for execution before the search engine fetches matching work items.

The change limits version lookups to the project named in a query, avoiding retrieval of millions of versions. For searches without a project filter, parallel requests in smaller batches reduced SQL fetch times from over 30 seconds to under 700 milliseconds in scale tests. Those batches keep PostgreSQL using its version index; their size must balance index use against excessive parallel calls.

## Sources

- [Inside Atlassian](https://www.atlassian.com/blog/jira/scaling-jira-to-6m-versions)

---
Canonical: https://techandbusiness.org/newswire/xRnpJ22SPr-MXU1MhVdJgI
Published: 2026-11-11T08:33:32.678Z
Story chronology: 2026-11-11T08:10:36.000Z
Retrieved: 2026-11-11T10:53:53.842Z
Publisher: Tech & Business (techandbusiness.org)