Page 1 of 1

Slowness populating Query Builder information

Posted: Mon Feb 06, 2017 4:30 am
by r1upfront
PrimalSQL2017
Version 4.3.58

64 Bit

It takes an extremely long time to populate the Query Builder information. Anywhere from 2 to 3 minutes once being dragged and dropping into the Query Builder area.

Re: Slowness populating Query Builder information

Posted: Mon Feb 06, 2017 7:04 am
by Alexander Riedel
Moved to correct forum by moderator

Re: Slowness populating Query Builder information

Posted: Mon Feb 06, 2017 11:15 am
by davidc
If you are using the Visual Query builder, the load time will depend on your settings, connection speed, and how large your database is. When you first load a database, it will attempt to build the schema and display it in the builder.

You can improve performance by making sure the Options->Panels->"Cache all fields" option is unchecked:
PrimalSQL - Cache all Fields.png
PrimalSQL - Cache all Fields.png (13.3 KiB) Viewed 14379 times
Alternatively, if you use the SQL only editor, it should display the file much faster since it doesn't have to build the information.