# Queries/Sec Slowing WAN Connection

**URL:** <https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917>\
**Category:** Ignition\
**Created:** [June 23, 2020, 2:55pm UTC](https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917 "2020-06-23T14:55:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathanlowery](https://avatars.discourse-cdn.com/v4/letter/j/7ab992/32.png) [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\
**Post date:** [June 23, 2020, 2:55pm UTC](https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917/1 "2020-06-23T14:55:52Z")

</div>

Have a Database Connection that seems abnormally higher in queries per sec.

Thought it may have been a WAN connection issue but i recently upgraded and it continues and in fact I can now see that just the DB connection along ties up 40 megs on the WAN.

 ![Ignit](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7de4cff80d43355099b7ee6ce42c7e9738415808.png)

---

<div class="post-metadata">

**Author:** ![jonathanlowery](https://avatars.discourse-cdn.com/v4/letter/j/7ab992/32.png) [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\
**Post date:** [June 24, 2020, 5:44pm UTC](https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917/2 "2020-06-24T17:44:45Z")

</div>

Anyone have any suggestions why one server would be querying so much?

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [June 24, 2020, 5:47pm UTC](https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917/3 "2020-06-24T17:47:28Z")

</div>

If you click details on it, it will show you the queries being executed.  
Then you can look at the scan classes of SQL tags using those queries.  
Or named queries, scripts, etc that are calling that query.

You need to dig down into the system and find what is calling that many queries.

---

<div class="post-metadata">

**Author:** ![jonathanlowery](https://avatars.discourse-cdn.com/v4/letter/j/7ab992/32.png) [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\
**Post date:** [June 24, 2020, 6:37pm UTC](https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917/4 "2020-06-24T18:37:08Z")

</div>

I’ve watched the active queries in details and never see more than 1-3 not 40 per second.

---

<div class="post-metadata">

**Author:** ![jonathanlowery](https://avatars.discourse-cdn.com/v4/letter/j/7ab992/32.png) [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\
**Post date:** [June 24, 2020, 6:40pm UTC](https://forum.inductiveautomation.com/t/queries-sec-slowing-wan-connection/35917/5 "2020-06-24T18:40:00Z")

</div>

Have no Named Queries. Had one tag which I had disabled before.