# Slow Query in Ignition

**URL:** <https://forum.inductiveautomation.com/t/slow-query-in-ignition/55908>\
**Category:** Ignition\
**Tags:** database\
**Created:** [February 9, 2022, 2:07pm UTC](https://forum.inductiveautomation.com/t/slow-query-in-ignition/55908 "2022-02-09T14:07:50Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 9, 2022, 7:10pm UTC](https://forum.inductiveautomation.com/t/slow-query-in-ignition/55908/3 "2022-02-09T19:10:46Z")

</div>

Found it - try SET ARITHABORT ON before executing the query:

> **[SQL Server stored procedure runs fast in SSMS and slow in application](https://www.mssqltips.com/sqlservertip/4318/sql-server-stored-procedure-runs-fast-in-ssms-and-slow-in-application/)**
>
> Our users complained about slowness in a few areas of our application. We ran Profiler and found that a few procedures were taking more than 6-10 seconds. I manually ran those same procedures in SSMS and they executed in less than second. Why?

---

_[View the full topic](https://forum.inductiveautomation.com/t/slow-query-in-ignition/55908)._