SQL exports which used to take seconds now take minutes

[expired user #8862]'s profile image [expired user #8862] posted 9 years ago in General Permalink
I'm on v9.1.0.49.41, and now when I do sql exports (I develop locally, so I often need to pull down a current db from production), it seems to take much, much longer than before. Have I inadvertantly changed a setting somewhere, or has the import process changed on this version? I haven noticed that the interface for doing sql exports has changed from what I'm used to.
ansgar's profile image ansgar posted 9 years ago Permalink
The "Max INSERT size" slows it down when you decrease it. Default is 1024KB. Lower values mean HeidiSQL has to pipe more often data to a string stream.

I intended to fix that somehow, but in the meantime you can just reset that setting to 1024K to get the normal speedy way back.
[expired user #8862]'s profile image [expired user #8862] posted 9 years ago Permalink
Ah, great, thanks for the tip, back to being speedy!

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