# \[BUG-5661\]Named Queries - Disble Table Browser update

**URL:** <https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702>\
**Category:** Ignition\
**Tags:** namedqueries, ignition81\
**Created:** [March 2, 2022, 8:57am UTC](https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702 "2022-03-02T08:57:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stefano\_Consolaro](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@Stefano\_Consolaro](https://forum.inductiveautomation.com/u/Stefano_Consolaro)\
**Post date:** [March 2, 2022, 8:57am UTC](https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702/1 "2022-03-02T08:57:39Z")

</div>

Hi all,  
I’m doing some test with Named Queries and when I am in the “developing” stage switching from Authoring and Testing it is boring to wait every time that the Table Browser update the table list.  
There is a way to disable this update?  
Thanks

---

<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:** [March 3, 2022, 12:13am UTC](https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702/2 "2022-03-03T00:13:49Z")

</div>

Ouch. Besides the fact that it probably doesn’t really need to fetch the list of tables every time you swap tabs, it _really_ shouldn’t be doing it on the EDT. I’ve filed a ticket to get this fixed.

Out of curiosity, how many tables are there in your DB, and how long does it take to bring in results?

---

<div class="post-metadata">

**Author:** ![Stefano\_Consolaro](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@Stefano\_Consolaro](https://forum.inductiveautomation.com/u/Stefano_Consolaro)\
**Post date:** [March 4, 2022, 8:44am UTC](https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702/3 "2022-03-04T08:44:50Z")

</div>

Hi, it takes over 10 seconds and the tables are over 1000.  
But I noticed today that in the list some table is repeated 20 time, other only one time, other 12 time…  
Can be an error in the database connection configuration?  
Thanks

---

<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:** [March 4, 2022, 8:51pm UTC](https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702/4 "2022-03-04T20:51:49Z")

</div>

It sounds like you might be listing tables in all schemas, instead of tables in a particular schema?  
How to filter that down is going to depend on a few factors, but you can contact support and they can help you get set up.

---

<div class="post-metadata">

**Author:** ![Stefano\_Consolaro](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@Stefano\_Consolaro](https://forum.inductiveautomation.com/u/Stefano_Consolaro)\
**Post date:** [March 8, 2022, 2:57pm UTC](https://forum.inductiveautomation.com/t/bug-5661-named-queries-disble-table-browser-update/56702/5 "2022-03-08T14:57:06Z")

</div>

If it can help the analysis, I use a DB2 connection with jt400.jar driver v.10.7.  
The person I spoke to, said that it can be a problem of the driver.  
For the time lock on switch a simple solution is to cancel the list update action.  
For the multiplication of the tables name there is no suggestion.