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

Hans Mayer

• 2018年01月23日 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 ★

  • 2018年01月25日 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 ★

  • 2018年02月22日 21:32
  • 編輯於

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

  0

請登入寫評論。