Opened file from network drive

I'm running Windows 10 on Virtual Box with HeidiSQL version 9.4.0.5174.

Whenever I open a file from my mounted drives seen as network drives, the memory usage goes up and up.

As seen in this screenshot, I've connected to my db server and then opened the file. I waited a few minutes without doing anything and the memory usage was above a 1024MB of ram.

When the same file is on my desktop, I don't have the same problem.

I have the save version of Heidi and do not see such behaviour with two different *nix file servers (aix and linux) and two different sql servers (local MySQL and remove MariaDB). I've tried this with ~1 KB .sql UTF8 file with unix EOLs as well as with 2.5MB .sql UTF8 file with windows EOLs.

Have you tried different sql files, different sql servers and different file servers?

Oh, I missed the part about virtual box.

You could try to specifiy the encoding in the file-open-dialog, e.g. "utf-8" or whatever it is. Don't use "Auto detect" - which is buggy, really.

Hi Anse,

Thank you for looking into this.

Tried different files, different encodings, different servers, different virtual box machines setup the 'same' way.

Seems it's not a network drive issue or encoding problem. I put the file on the desktop of the Windows machine and on a real networked drive and the resources are fine.

The issue is when the file is on a mounted drive accessible to the Windows VM from my Linux host and I open any sql file the memory and cpu climb.

I'm using Oracle's VirtualBox version 5.1.26 r117224 (Qt5.5.1)

If at all this issue still exists, the current build may heal something here. I pushed a change for fixing successive "reload file?" prompts, for files on a network drive.

See this related thread, or just try it and update to the latest build.

Hi Anse,

I can see now it's a much bigger problem as the app almost immediately becomes unusable and sends the CPU to about 60% and a slow upwards memory leak.

As a followup, the latest build ( 10.2.0.5769 ) has the same issue.

Are there similar symptoms in other software, e.g. Notepad++ or whatever has some watch-file-modification feature?

Hi Anse,

I have no issues with Sublime Text and having files open from the same drive. I even edited the file in SSMS and there was no issue with Sublime reading the update and not consuming memory or CPU.