# Disabling SQL query binding on power table **URL:** \ **Category:** Ignition\ **Created:** [October 17, 2018, 3:31am UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215 "2018-10-17T03:31:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Post date:** [October 17, 2018, 3:31am UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/1 "2018-10-17T03:31:50Z")
I have an SQL query binding on a table that is linked to a Date Range component. When the Date Range component is put into Realtime mode, it updates the Start and End time every so often, which means the SQL query is updated at the same rate. I’ve noticed this can cause performance issues with the query being repeated so often. I was hoping that disabling the table component would prevent query being executed, but this doesn’t seem to be the case. Is this a bug or intentional behavior? Cheers ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 17, 2018, 12:03pm UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/2 "2018-10-17T12:03:51Z")
Intentional behavior. You’ll have to constrain realtime mode to update slower than your query execution time. ---
**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Post date:** [October 17, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/3 "2018-10-17T19:31:17Z")
How can you change realtime update period? I actually had the query execution set to “off”. Trouble is, because the WHERE statement changes every time the date-time changes, it executes in time with realtime update period. Is there a different way to approach it where I could use a custom property bound to date range that only updates in historical mode or something? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 17, 2018, 8:42pm UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/4 "2018-10-17T20:42:28Z")
> [@richardNZ15](#): > > How can you change realtime update period? That's customization somewhere in that window. Unlike an EasyChart, there's no automatic realtime mode in the standard date range component. Find what is supplying the end-date when you selected realtime mode. Change that to update less often. (EasyChart has a poll rate property, for instance.) ---
**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Post date:** [October 17, 2018, 11:38pm UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/5 "2018-10-17T23:38:29Z")
Ah sorry i am actually using an Easy Chart component, and utilizing Start and End date from that. Not a Date Range component. Where is the poll rate property on an Easy Chart? I have tried looking for that before. I always thought it polled based on the Client Poll rate specified in the Project Properties under Client/Timing. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 18, 2018, 1:42am UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/6 "2018-10-18T01:42:23Z")
It’s called “Poll Rate”, and its under the “Behavior” section of an EasyChart’s properties. (-: ---
**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Post date:** [October 18, 2018, 2:44am UTC](https://forum.inductiveautomation.com/t/disabling-sql-query-binding-on-power-table/20215/7 "2018-10-18T02:44:20Z")
Geez i must be blind, can’t believe i’ve skimmed over that for so long. Thanks. 👍