Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Query takes 17 seconds, export grid rows takes forever

kragtorp's profile image kragtorp posted 1 year ago in Import/Export Permalink


I run a query that takes about 17 seconds to complete. However, to right click the results and choose 'export grid rows' takes probably 5-10 minutes just for the save dialogue to show up, then another 50 minutes to actually save the output.

Take a look at the attached image to see the query (can't copy&paste now as the dialogue is in state (Not responding)

Why is this so slow? Are there some settings I can adjust?

I am using HeidiSQL Portable (and had this problem with all previous releases also)

1 attachment(s):
  • sql

Please login to leave a reply, or register at first.