Move import of large SQL files into background thread -> GUI won't hang anymore

CoolWater's profile image CoolWater posted 11 years ago in Import/Export Permalink
When importing large SQL files, HeidiSQL starts showing progress in "Run SQL file" window. After the third/fourth large SQL command or after "ALTER TABLE xy ENABLE KEYS" (large table, several indexes), the GUI stops responding until entire import process has finished. It seems that HeidiSQL performs all the statements in GUI thread. So it would be good to do that in a background thread. This would also make a "Cancel" button possible without using PeekMessage/GetMessage/TranslateMessage/DispatchMessage (which would slow down the import process measurably)...

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