[BUG-14319] "SQL Query Builder" is very slow and overloads the PC

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.

Best Regards.

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.

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

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.

Good morning.
The database has got more than 4000 tables. I had not checked. Excuse.

image

But, ¿Why does “Database query browser” load perfectly and “SQL Query Builder” never load?

Best regards.

They are different systems doing different things – the query builder lets you do graphical building of queries, so it’s a more complex system.

In agreement. Sorry for the inconvenience.

Best Regards.

We’re tracking this as a bug and when it eventually gets looked at / fixed someone should come by and update this post.