I have a large table (7.5GB; 1.3 million rows; fixed rows, around 5952 bytes). When I try to export this table with data (either to zip or directly to another sql server), Heidi tries to fetch entire table, instead of splitting everything into chunks (Max INSERT size doesn't work). And cancel button doesn't work either, cause entire app is hang up on the current query.
If I were to guess, the problem for Heidi is my primary key (it uses 2 columns).
It consists of (in specified order):
Do you think you can fix it?