Export to Excel CSV takes long time

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?

*100K rows sorry

Which server version? And which HeidiSQL version?

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

Heidi 10.3.0.5862

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?