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

Hans Mayer

• 23 janvier 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 ★

  • 25 janvier 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 ★

  • 22 février 2018 21:32
  • Modifié

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

  0

Vous devez vous connecter pour laisser un commentaire.