[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

2 评论

Shotaro Ito

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.

Darryl Christensen

2018年02月22日 21:32

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

请先登录再写评论。