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

Hans Mayer

• January 23, 2018 14:38

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

1

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • January 25, 2018 04:56

  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
• 

  Darryl Christensen

  ★ BarTender Hero ★

  • February 22, 2018 21:32
  • Edited

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

  0

Please sign in to leave a comment.