Slowness populating Query Builder information

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 7 years and 1 month old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
r1upfront
Posts: 1
Last visit: Tue Nov 02, 2021 1:42 pm

Slowness populating Query Builder information

Post 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.
User avatar
Alexander Riedel
Posts: 8478
Last visit: Tue Mar 26, 2024 8:52 am
Answers: 19
Been upvoted: 37 times

Re: Slowness populating Query Builder information

Post by Alexander Riedel »

Moved to correct forum by moderator
Alexander Riedel
SAPIEN Technologies, Inc.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: Slowness populating Query Builder information

Post 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 14351 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.
David
SAPIEN Technologies, Inc.
This topic is 7 years and 1 month old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.