Bug when larger file is imported

Kcko's profile image Kcko posted 3 months ago in General Permalink

Hi Ansgar,

I probably found bug.

If I import a larger data set from a SQL file (for example 5MB) and it takes some time, the bottom panel freezes after the action is completed (I use Windows 11). I can't click on any running window or application afterwards and it takes some time (usually 2-4 minutes).

I can either wait or restart explorer in task manager.

Is there any solution? I have standard Windows 11.

Is it because heidi eats a lot of RAM when importing a file?

Kcko's profile image Kcko posted 3 months ago Permalink

i thought windows bottom panel

Kcko's profile image Kcko posted 3 months ago Permalink

Same thing happen when i make export of larger set of rows ... ;)

ansgar's profile image ansgar posted 3 months ago Permalink

So you mean the Windows taskbar, not the "bottom panel" of HeidiSQL?

When you opened that SQL file, did you select "Run file", or "Load into editor", or weren't you even asked for one of these actions? Starting at 5MB, HeidiSQL normally asks you.

Kcko's profile image Kcko posted 3 months ago Permalink

Hi Ansgar,

Yes, I mean Windows taskbar (W11)

I've run it in both modes, both suffer from the same problem (I observe it on WIN 11).

I don't do this operation often (except now I'm migrating tables from one db to another manually, so I'll suffer for a while).

It's probably nothing major (I don't do exports every day), but I wanted to point it out.

But here is short video -> https://bit.ly/474GZSN

After import/export is done, windows taskbar free for some time (2-3min), and then everything works again and you can click on tabs and windows.

If I don't want to wait, I have to manually restart Explorer via processes.

Kcko's profile image Kcko posted 3 months ago Permalink

taskbar free = freezes

ansgar's profile image ansgar posted 3 months ago Permalink

Your Windows taskbar looks a bit strange to me, and it hides the status panel in HeidiSQL, which should be visible and even show what's currently going on:

Description

These single INSERT commands need some time to execute, especially if you have lots of them. A much quicker way is to use the extended INSERTs with many rows in one SQL command. Though this slowness does not explain why your taskbar is unresponsive.

Kcko's profile image Kcko posted 3 months ago Permalink

I understand.

As far as separate queries are concerned, this is how HEIDISQL generates it for me. Since the tables between DEV and PROD DB do not have the same columns, I use this method see the following screenshots.

https://bit.ly/3t0trd1 https://bit.ly/3TbYLQF

Anyway, thanks for the explanation, I guess there is no need to solve this further, I will finish the task and leave it :-)

Wouldn't it be possible to add %table% to the export mask?

I'm exporting table by table and it's boring to type it manually :-)

ansgar's profile image ansgar posted 3 months ago Permalink

Yea I see. This is quite a very manual click process :)

I recommend to synchronize the table structure on your DEV and PROD, so it will be much easier to sync the data between them. When both schemata are equal, you could use the SQL export feature for data syncing.

To answer your question: sorry, there is no way to add a custom table name like %table% to the grid export.

Kcko's profile image Kcko posted 3 months ago Permalink

OK, in conclusion here is last video with smaller file (about 2MB) taskbar is always visible but still freezes https://bit.ly/3ta8Nad

*Yea I see. This is quite a very manual click process :)

I recommend to synchronize the table structure on your DEV and PROD, so it will be much easier to sync the data between them. When both schemata are equal, you could use the SQL export feature for data syncing.*

I know that, in this particular case, that is not possible. Still, thanks for this great tool and it helps me a lot anyway.

And really for the last time, how are we doing with the export window filter? ;-)

Kcko's profile image Kcko posted 3 months ago Permalink

Btw problem is solved.

I had installed a paid version of START 11 ( https://www.stardock.com/products/start11/ ) which corrected the imperfect behavior of windows, panel, icons, etc during the transition from W10 -> W11.

Sorry. (After uninstalling, the bottom panel doesn't freeze), but maybe this topic will help someone find the problem sometime in the future.

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