# Troubleshooting slow query in ignition.gateway.localdb.sqlite.singleConnectionDatasource

**URL:** <https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [October 21, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566 "2024-10-21T20:22:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isaac\_Hodgkins](https://avatars.discourse-cdn.com/v4/letter/i/59ef9b/32.png) [@Isaac\_Hodgkins](https://forum.inductiveautomation.com/u/Isaac_Hodgkins)\
**Post date:** [October 21, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566/1 "2024-10-21T20:22:59Z")

</div>

I've been trying to troubleshoot an issue with the gateway locking up, and it seems to be caused by an issue with a slow query on the localdb. I turned com.inductiveautomation.ignition.gateway.localdb.sqlite.SingleConnectionDatasource to the trace level in the log to try to troubleshoot which queries are bottlenecking the gateway, but all it gives me is a connection id. Is there anyway to see which scripts/triggers these connection ids are linked to so I can see what is responsible for slowing down the gateway? Thanks!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/3/13ebfd1bc036c92bb5d6d17856e6ac1423a0113a.png)

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [October 21, 2024, 8:51pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566/2 "2024-10-21T20:51:09Z")

</div>

Is there any more useful information when you hit the `+` symbol beside the log message?

---

<div class="post-metadata">

**Author:** ![Isaac\_Hodgkins](https://avatars.discourse-cdn.com/v4/letter/i/59ef9b/32.png) [@Isaac\_Hodgkins](https://forum.inductiveautomation.com/u/Isaac_Hodgkins)\
**Post date:** [October 22, 2024, 7:53pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566/3 "2024-10-22T19:53:10Z")

</div>

No not really

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [October 22, 2024, 7:57pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566/4 "2024-10-22T19:57:05Z")

</div>

Contacting support would be best.

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [October 22, 2024, 8:00pm UTC](https://forum.inductiveautomation.com/t/troubleshooting-slow-query-in-ignition-gateway-localdb-sqlite-singleconnectiondatasource/97566/5 "2024-10-22T20:00:21Z")

</div>

What are you using a sqllite database for? A sqllite database should only be used in very minimal applications... and if you are using it for a historian then I'm no surprised that you are having this issue. Go get a real database... Postgresql, mariaDB.