Screen Refresh

[Marcwolf]

I use SQLyog.. A Lot.

Its my main tool for MySQL work (Many thanks guys for an excellent product ) My boss has brought several licenses for us to use.

But with V4.1 and previous I have always had an issue. Hopefully this can be fixed in V4.2

It the Screen refresh capability.

I use Windows 2000 and I often have a very busy desktop. When I have SQLyog open and I minimise it and then give SQLYog the focus back – it does not refresh its screen correctly.

I am left with gaping gray area's that I am not sure what is under. Often I am tempted to close down SQLyog rather that to risk randomly clicking in a hope to get the screen refreshed. Random Clicks on Live data is a peril I do not wish to chance.

I have also noticed similar refresh/update issues when I have a long script or backup/restore running. As I have the smaller window showing how many records are being updated and number of queries run. If I move something over the window I loose that information and thus cannot estimate time of completion etc.

Hope this is not too difficult to fix. Possible do a check when SQLyog gets focus and then do a window refresh.

Many thanks Guys..

P.S. – again – really great product

[peterlaursen]

I think we have two issues. One is related to SQLyog the other is not.

1) SQLyog is not multithreaded. So when it is busy with one job, it can't do anything else. Even not refresh the display of itself. If I understand you right that could explain this

Quote:

I have also noticed similar refresh/update issues when I have a long script or backup/restore running. As I have the smaller window showing how many records are being updated and number of queries run. If I move something over the window I loose that information and thus cannot estimate time of completion etc.

A workaorund could be to use “virtual desktops”, that are available for instance with most modern graphics drivers, so that you won't have to have another program window over sqlyog. There is not fix for lack of multithreadedness in 4.2. It is a COMPLETE revamping of the code.

However what you write in the beginning

Quote:

I use Windows 2000 and I often have a very busy desktop. When I have SQLyog open and I minimise it and then give SQLYog the focus back – it does not refresh its screen correctly.

is a problem with your system I believe. Som driver conflict maybe. Most likely a conflict between the graphics driver and some wireless (mouse, keyboard, wireless LAN). Of course I can't know, but I don't experience that with SQLyog and my 2 systems.

Do yo experience that on MORE ( and diffferent) systems? And no other program behaving like that?

You could try running the program in “failsafe” mode. That should eliminate most driver problems. Also try uninstall the graphics driver and use Windows' standard .. or the other way around … And try another Grapics card, if you have the chance.

It will be very diffucult to reproduce your problem.. It would take a complete “copy” of your system. OS, SP-level, drivers, hardware …

[peterlaursen]

Just one question.

Quote:

use Windows 2000 and I often have a very busy desktop. When I have SQLyog open and I minimise it and then give SQLYog the focus back – it does not refresh its screen correctly.

Is SQLyog busy with something when you minimize it and give it focus back? then this could be because of the lack of multithreadedness too.

[Ritesh]

Can you post some screenshots?

[Marcwolf]

Re the screen shots – I will try.. Its a little tricky as I am working on the desktop and that SQLyog is not really 'broken', its just has not rememebred to refresh its screen.

Re the multi threadedness – yes – that could be a big factor as it is often when I have something running on SQLYog that I will minimize it so I can do other development.

I'll try and keep you posted on this one.

Dave

[Author]

Posts