MariaDB 10 query slow in Windows 10

[pipo975]

Hello all!

I have an old program written in Delphi 7. Currently i have ZeosLib 7.0.3. installed. And I'm not really an expert.

If I run program in Windows 7/64bit everything seems ok.
But in Windows 10/64bit everything seems much slower. In Windows 7 the data are shown almost immediately, in Windows 10 it takes more than 2 seconds on workstation and 5 – 10 seconds on desktop PC. At least "SQLHourGlass" is blinking this long on screen.
The queries are the same on all systems.

I'm running MariaDB 10 on NAS Synology drive.

Any clue why is this difference between Win7/10?

Thanks!

[marsupilami]

Hello,

it could be the SQL hour glass. I had similar problems in one of my programs. For some reason changing the mouse cursor back fom SQL Hourglass to the regular hour glass can take quite some time on Windows 10. To prevent this, I added explicit changes from regular mouse cursor to SQL HourGlass and back before openeing a lot of queries. This significantly improved performance for me:

Code: Select all

ZConnection.ShowSqlHourGlass;
try
  // open queries here
  Zquery1.Open;
  //...
  ZQueryN.Open;
finally
  ZConnection.HideSqlHourGlass;
end;

Upgrading from Zeos 7.0 to Zeos 7.2 also might improve your performance.

Best regards,

Jan

[pipo975]

Thanks Jan!

Disabling SQL hour glass seems to solve the problem.

I've tried on Delphi 10 and latest ZeosLib. But the only thing that helped was SQL hour glass. It's also working on old Delhi 7.