SQL exports which used to take seconds now take minutes
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.
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.
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.
Please login to leave a reply, or register at first.