distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

User, date Message
Written by CoolWater
2 years ago
Category: Import/Export
8 posts since Sat, 31 Dec 11
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.