I open sql file with multiple sql commands (import of 8330 tables with data) and choose load file into the editor. Than I press F9 to execute all sql commands in file and Heidisql stop responding until i close it abruptly. I uninstalled Heidisql and installed 10.2.0.5599 version and it works OK, but not the last last version.
Importing of sql file (F9) doesn't work anymore
No, it can't be the size of file (only 37 MB). I uninstalled HeidiSQL and reinstalled the latest version on your site and it works like a charm. Than I repeated the procedure with build 5745 and the program freeze when I press F9. You can look at attached printscreens. I waited for 10 minutes and nothing happened.
Yes, I can now confirm that, with a random SQL file which has 600kb only. Really strange. Also, it's not caused by my recently modified check for unsafe queries (issue #685)
In prior versions of HeidiSQL when I pressed F9 to start executing queries it started right away, now it is checking something, I can see it in status bar and it takes quite a long time before start of executing queries. If it is some important check of queries I can live with it, but if it's not it's only time consuming.
Issue #685: Fix fatal performance bug, calling GetSQL on each examined character of a TSQLSentence. See report on https://www.heidisql.com/forum.php?t=34935
I found the cause and just fixed it. Please update to the latest build again.
For more details look at issue #685
Please login to leave a reply, or register at first.