Importing of sql file (F9) doesn't work anymore

mbedrac's profile image mbedrac posted 4 years ago in Import/Export Permalink

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.

mbedrac's profile image mbedrac posted 4 years ago Permalink

Mistake, I meant 830 tables (about 37 MB).

ansgar's profile image ansgar posted 4 years ago Permalink

I can't reproduce that here, queries are executed fine.

Is it probably that the file is huge and takes some time?

mbedrac's profile image mbedrac posted 4 years ago Permalink

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.

2 attachment(s):
  • HeidiSQL_Frozen-screen
  • HeidiSQL_CPU-consumption-when-frozen
ansgar's profile image ansgar posted 4 years ago Permalink

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)

mbedrac's profile image mbedrac posted 4 years ago Permalink

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.

Code modification/commit 7b99bcc from Ansgar Becker <anse@heidisql.com>, 4 years ago, revision 10.2.0.5748
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
ansgar's profile image ansgar posted 4 years ago Permalink

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.