# How Many Queries per Second is Too High?

**URL:** <https://forum.inductiveautomation.com/t/how-many-queries-per-second-is-too-high/40540>\
**Category:** Ignition\
**Tags:** ignition79, database\
**Created:** [November 11, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/how-many-queries-per-second-is-too-high/40540 "2020-11-11T16:32:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![paulm1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paulm1/32/5900_2.png) [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\
**Post date:** [November 11, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/how-many-queries-per-second-is-too-high/40540/1 "2020-11-11T16:32:27Z")

</div>

I have a MySQL Database that is averaging 97 queries per second.  
What is considered too many?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [November 11, 2020, 4:35pm UTC](https://forum.inductiveautomation.com/t/how-many-queries-per-second-is-too-high/40540/2 "2020-11-11T16:35:07Z")

</div>

> [@paulm1](#):
>
> What is considered too many?

When your database machine falls over. If it's keeping up (CPU and memory usage are reasonable) then the right number for queries/second is whatever your application needs.

---

<div class="post-metadata">

**Author:** ![paulm1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paulm1/32/5900_2.png) [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\
**Post date:** [November 11, 2020, 4:41pm UTC](https://forum.inductiveautomation.com/t/how-many-queries-per-second-is-too-high/40540/3 "2020-11-11T16:41:53Z")

</div>

Excellent. Thank you.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [November 11, 2020, 4:55pm UTC](https://forum.inductiveautomation.com/t/how-many-queries-per-second-is-too-high/40540/4 "2020-11-11T16:55:00Z")

</div>

Ignition has a nice feature where you can see the slow logs under the database status. Optimizing your slow queries could mean less queries per second if you have a lot of queries stacking up. Just in case you ever notice you do go over the limit it’s not a bad place to start.