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.

Export to Excel CSV takes long time

aSystemOverload's profile image aSystemOverload posted 2 months ago in General Permalink

It takes upto five minutes for ~100 rows of 20 columns, never used to take more than around a minute, but exports seem to take ages now. Any idea why this might occur?

aSystemOverload's profile image aSystemOverload posted 2 months ago Permalink

*100K rows sorry

ansgar's profile image ansgar posted 2 months ago Permalink

Which server version? And which HeidiSQL version?

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.
aSystemOverload's profile image aSystemOverload posted 2 months ago Permalink

Microsoft SQL Azure (RTM) - 12.0.2000.8 // Dec 4 2019 21:24:18 // Copyright (C) 2019 Microsoft Corporation

Heidi 10.3.0.5862

ansgar's profile image ansgar posted 2 months ago Permalink

Ok, that's a newer build with a fix for issue #804 - it should actually be faster, not slower than before. But that fix only applies to the slow calculation of the estimated export file size. The export itself takes here ~15seconds for a 40k rows table. Not sure what is so slow on your end. Maybe I need that table because it's more complex?

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