Editor pane not refreshing fast when updating text

[jungle-boogie]

Hi,

This may need more experimenting and investigating on your part, because I'm not exactly certain what I'm seeing is related.

It seems saving a query (maybe multiple saves) cause the editor pane to become sluggish and doesn't update to edit/view the query.
The app never crashes or becomes unresponsive, but the editor pane doesn't refresh allowing you to see the text very well.

Thanks!

[jungle-boogie]

Here's a video demo of what I'm explaining:

sqlite-gui-25.mp4

I actually didn't have any queries saved, so maybe it's the auto complete that's causing issues?

[little-brother]

Could you attach an query text?
How long does the app work before this behaviour?

[jungle-boogie]

I started the recording just seconds after opeining the app.

I would suggest trying to make an elaborate query with the default DB and seeing if you get the same results.

[little-brother]

How do you change a words and their cases? I didn't see autocomplete and it doesn't like you input text as usual (maybe fps is not enough). Is it some hotkeys?

[jungle-boogie]

Hi, I select text with shift + arrow keys. Also test shift + home and end keys. The video recorded what I saw and experienced. This is not a video playback issue.

[little-brother]

This issue can be related with a long query text and a slow PC.
Can you run the Task manager > Performance, edit the query and check CPU usage?

If you turn off a text highlighting in Settings, then the problem disappears?

[jungle-boogie]

Hi,

My computer may be slower and older than yours, but I have an SSD drive and don't experience any slow issues with any other apps.

[jungle-boogie]

Hi,

On a different PC, I see the same results. Highlighting text and replacing it causes the lag with typing.
Task Manager peeked at 18% CPU but only very briefly.

Could this be related to sqlite-gui trying to auto complete and it choking on something?

[little-brother]

but I have an SSD drive and don't experience any slow issues with any other apps.

It doesn't matter what kind of drive you are use. Currently the entire text is fully re-colorized on any change. It requires multiply non-disk API calls to an editor to colorize each word and extremely slow if the text is long enough. The solution is to colorize only the visible text. I try to implement it.

Please check a version without autocomplete - https://disk.yandex.ru/d/5ASPgXWCkR8E3Q to confirm or deny my suppose.

[jungle-boogie]

Thanks for your analysis. I'll try that version of sqlite-gui out soon.

[jungle-boogie]

Hi,

There are some improvements but I still see the problem.

Now all the text appears very quickly after I stop typing, but it doesn't keep up with my typing. Sometimes pressing the down arrow key causes the updated text to appear.

Once I get it to happen the first time, it seems to always occur, just like before.

[little-brother]

Could you provide your OS, the query line count and CPU model?

Now all the text appears very quickly after I stop typing, but it doesn't keep up with my typing. Sometimes pressing the down arrow key causes the updated text to appear.

Hence, it's a not a highlighting issue and autocomplete is more likely.
The down arrow-key is a very strange. This button doesn't trigger the highlighing update. Maybe a caret is placed to parentheses?

[jungle-boogie]

Could you provide your OS, the query line count and CPU model?

Windows 10 version 1809 OS build 17763.1879 on a Intel core i5-2400 cpu 3.10GHz

The query I'm executing is 14 lines, but it's only using 1 table in my database.

[little-brother]

i5 is more than enough to work without lags. So I need to get Win10 for testing because I use Win7x64 and I can't reproduce this bug. The Ctrl + Alt + Esc also works fine on WinXP/Win7.

Thanks for information.

[little-brother]

I repeated this error in Win10.
Also I noticed that under Win10 the app is much slower. Perhaps I should change a compiler.

[jungle-boogie]

Oh, good to hear you were able to find a machine, and experience the same/similar problem.

[little-brother]

It looks like that msftedit.dll (is used for editors) in Win10 is a little buggish or works internally different :(
The silly solving is to place msftedit.dll (C:\Windows\SysWOW64\msftedit.dll) from Windows 7 to sqlite-gui folder.
P.S. Win10 file is 5 times larger that Win7.

[jungle-boogie]

That DLL does seem to make a difference.

Do you also notice some improvements?

[little-brother]

With Win7 dll I couldn't reproduce the paint bug and (possibly) the app works faster.
I think to include this dll to the app distributive because it's the easiest to solve the problem.

[jungle-boogie]

Yes, seems like app works faster with this DLL.

Glad we got this one taken care of - good job!