# \[BUG-14319\] "SQL Query Builder" is very slow and overloads the PC **URL:** \ **Category:** Ignition Early Access\ **Created:** [June 25, 2019, 3:52pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084 "2019-06-25T15:52:27Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [June 25, 2019, 3:52pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/1 "2019-06-25T15:52:27Z")
Good afternoon. When I am doing a report, if I try to show the “ **SQL Query Builder** ” for a database with **many tables** (more than 100), the “Builder” does not load or it takes a lot (more than 20 minutes) to load and **overloads the PC** (my PC is i5 with 8GB RAM) On the other hand, if I open the “Database query browser” panel, the tables are displayed without delay. This occurs in Ignition 7 and 8. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3e9e32c1e11a735ddc49ddf3c6ac24417d0b84da.png) Best Regards. ---
**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:** [June 25, 2019, 7:46pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/2 "2019-06-25T19:46:14Z")
Your PC may have 8GB of RAM, but you’ve only given the Designer 936 megs. Any time you’re dealing with reports, my rule of thumb is to let the designer have at least 2GB, since just about every part of the report designer chews up memory. ---
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [June 26, 2019, 8:25am UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/3 "2019-06-26T08:25:57Z")
Good Morning. It is not a maximum memory problem. As you can see in the video, the designer uses about 200 megabytes. It is an internal problem of “SQL Query Builder”: with a database that contains many tables it never ends loading. Anyway, I have tried to establish the designer’s memory in 4 GB and the problem continues. On the other hand, if I open the “Database query browser” panel, the tables are displayed without delay. https:/uploads/iatesting/original/2X/d/dc8ca20167d98461f7752fe248936b330e8e9725.mp4 ---
**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:** [June 26, 2019, 3:17pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/4 "2019-06-26T15:17:17Z")
I can’t replicate this at all. I made a database with 150 tables, each having data. With a designer with 2GB of RAM allocated it took 2.5 seconds to load the query builder in the reporting module; with a low RAM designer it took 4 seconds. (Ignition 8.0.3 build from June 21) You might need to contact support to see what’s going on, because there’s clearly something very different between your system and mine. Be sure to reference this forum post to save some time. ---
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [June 27, 2019, 8:17am UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/5 "2019-06-27T08:17:50Z")
Good morning. The database has got more than 4000 tables. I had not checked. Excuse. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f59bdffdb3ad4a429d0abb90e516436287627619.png) But, ¿Why does “Database query browser” load perfectly and “SQL Query Builder” never load? Best regards. ---
**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:** [June 27, 2019, 2:09pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/6 "2019-06-27T14:09:28Z")
They are different systems doing different things – the query builder lets you do graphical building of queries, so it’s a more complex system. ---
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [June 27, 2019, 4:32pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/7 "2019-06-27T16:32:46Z")
In agreement. Sorry for the inconvenience. Best Regards. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [June 27, 2019, 4:46pm UTC](https://forum.inductiveautomation.com/t/bug-14319-sql-query-builder-is-very-slow-and-overloads-the-pc/26084/8 "2019-06-27T16:46:41Z")
We’re tracking this as a bug and when it eventually gets looked at / fixed someone should come by and update this post.