Export SQL dialog rewritten and lightning fast now
Apart from the GUI changes, I rewrote the whole bunch of code which loops through your table rows and creates INSERTs. Probably you have noticed the old dialog was very slow when it came to export large tables. Not so the new dialog - it is nearly as fast as mysqldump does an export!
I have a 23M table with 1,1 Mio rows, used for testing purposes:
* Old HeidiSQL export took ~1 minute
* New dialog: 10 seconds
* mysqldump: 4 seconds
Another 5M table with 40,000 rows:
* Old dialog: 22 seconds
* New: 1 second
* mysqldump: 1 second
The problem with the old dialog was slow string concatenation in Delphi, which is now solved using TStream and TFileStream as a replacement.
See it in action by downloading the latest build (Help > Check for updates)
Also, views are now supported here. Stored routines will follow.
Did you notice the tree on the left lets you select the whole server so you are able to create a complete server backup now in two clicks!
Please login to leave a reply, or register at first.