# Limiting Designer Query Sizes **URL:** \ **Category:** Ignition\ **Created:** [December 7, 2022, 6:30pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351 "2022-12-07T18:30:52Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![kyler.kamyszek](https://avatars.discourse-cdn.com/v4/letter/k/a4c791/32.png) [@kyler.kamyszek](https://forum.inductiveautomation.com/u/kyler.kamyszek)\ **Post date:** [December 7, 2022, 6:30pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/1 "2022-12-07T18:30:53Z")
Is there a way to limit number of rows that get returned from any query when in designer? Other than just normal db best practices? I have a large database table, and a contractor didn't put a 'Top' condition in and it was crashing the gateway because of the heap size. ---
**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:** [December 7, 2022, 6:34pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/2 "2022-12-07T18:34:13Z")
No. ---
**Author:** ![craigb](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Post date:** [December 7, 2022, 7:12pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/3 "2022-12-07T19:12:35Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/0/e0ff436e17b5d7cda175f0a4183434f26906db75.png) ---
**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:** [December 7, 2022, 8:14pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/4 "2022-12-07T20:14:22Z")
That's purely for named queries invoked from bindings. Scripted queries, query browser queries with the 1000 row limit checkbox turned off, etc, will all get everything they are told to. ---
**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:** [December 7, 2022, 11:59pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/5 "2022-12-07T23:59:51Z")
To fix it, disable the database connection on the gateway. Open the page in designer and adjust the query. Enable the database connection, Don't ask how I know this 😛 ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [December 8, 2022, 4:11pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/6 "2022-12-08T16:11:23Z")
Yikes, this is sounding like a bug. I'm sure it was a while back, but can you remember any more details @MMaynard that will help us track this down? e.g. named query? query binding? approximate ignition version? the specific swear words you said? 😜 ---
**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:** [December 8, 2022, 6:35pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/7 "2022-12-08T18:35:04Z")
_IF_ I remember correctly it was during a development and it was on a very large SQL Table(a few million rows) When you went to try and open the window it was trying to load the entire table. So we disabled the db connection, opened the window, limited the select on the table and saved. Then re-enabled the DB connection. ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [December 8, 2022, 6:37pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/8 "2022-12-08T18:37:38Z")
Ah, gotcha. I can see that happening. I was thinking this was an issue with the change not taking effect if you didn't pause the DB connection, which would be very, very bad. ---
**Author:** ![craigb](https://avatars.discourse-cdn.com/v4/letter/c/9f8e36/32.png) [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Post date:** [December 8, 2022, 7:01pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351/9 "2022-12-08T19:01:14Z")
Could you use one of these (type, userAgent) to create a limit Claus in a if statement or similar? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/0605fb0b5f45dd4c080b5acabbd64018647c2e3a.png)