[Solution]: Query Prompt slow, SQL Connection slow, Printing slow Follow

1
Avatar
Hans Mayer

We had a query prompt and 3 SQL tables with outer join.

Printing was extremely slow (from clicking Print => to Query Prompt windows) and I suspected the SQL data connection was the issue.

But the solution is: disable "autocomplete" in Query Prompt and this makes it faster by factor 10 or more in our case : https://i.imgur.com/0EduiUJ.png

2 comments

0
Avatar
Shotaro Ito
Moderator
Comment actions Permalink

Cool... Thank you so much for sharing!

Yes, autocomplete would query in anytime showing query prompt input so that makes sense for bulk data / complex query.

0
Avatar
Darryl Christensen
Comment actions Permalink

This reduced load time of the query prompt 10x for me. Thanks.

Please sign in to leave a comment.