[DoctorScottPA]

I’m also seeing this behavior in 12.16 on Windows 7 Pro (64-bit). Windows has been restarted several times since the installation of this version. I’m using Kaspersky Anti-Virus version 15.0.2.361.

 

It seems that anything related to user preferences / connection profiles is really slow.  For example, I opened the Tools > Preferences > Other tab to deactivate the “Restore session on startup” option.  When I pressed the OK button to apply the setting, the program went “Not Responding” for several minutes.  Something similar happened when I tried to update the server name of the SSH server for a saved connection.  The UI went “Not Responding” for several minutes but eventually finished the action, though the connection information was not actually updated.

 

When I monitored the process thread activity using SysInternals Process Monitor, I saw repeated attempts by SQLyog.exe to access sqlyog.ini in my AppData directory (D:UsersusernameAppDataRoamingSQLyog).  These attempts failed despite the fact that I owned the file and had full rights to it.  When I changed the permissions of the file to give all users Modify and Write rights (they previously had Read & Execute and Read), the UI magically became more responsive and the settings were properly saved.  After the change other seemingly unrelated activities, such as exporting the records to the clipboard, also became regular activities instead of agonizingly slow.

 

I would have assumed that SQLYog would have accessed sqlyog.ini as the currently-logged-in Windows user, but apparently not… but it seems like we may have a workaround!

[Author]

Posts