Object browser still slow

[guttormvik]

Expanding tables directly after logging on takes at least 20s.

Doing a "select table_name from user_tables" returns 887 rows in 0.56 seconds, so it is not the db connection that is the problem.
Plyxon is using around 9% cpu while this is going on, so it looks like the issue is local.

If I expand & close some of the other ones, like trigger, packages, and then expand tables, it takes almost a minute.

Curiously, triggers, and only that, seems to be "loading"/built progressively.
It is not a big improvement, since I don't want to scroll around in it while it is changing.

After having opened and closed several of these, filter is really slow ( > 1 min) and removing the filter is even slower ( > 3 min)

Looks like the control you are using isn't suitable for a large number of entries.

Out of curiosity; What are you using?

 

[Marco Kalter]

Are you using the current 0.9.3.530 version? Go to Help > About to verify this.

Can you also let me know your OS?

 

[guttormvik]

I had a bit of confusion about the version, ie "xx.3.xx" being "Alpha 4".. but it *is* the latest one: 0.9.3.530
This is on Windows 10 Enterprise 22H2

 

[Marco Kalter]

We could reproduce this and will fix it. I will post a test version for Windows here later today or tomorrow.

 

[Marco Kalter]

Can you try this test version for Windows?

64 bit:https://www.allroundautomations.com/files/plyxon-0.9.3.534a-win64.msi
32 bit:https://www.allroundautomations.com/files/plyxon-0.9.3.534a-win32.msi

Let me know if this fixes the issues!

 

[guttormvik]

Much better. Now all the sublevels in the object browser opens "immediate" ( < 0.5s )

When I've opened and closed all sublevels, filtering and unfiltering both take about 5s
In total there are probably around 4K items then.
This is totally usable, but still room for improvement.

Scrolling around in a long list is still sluggish, but not unusable.

Btw; I wouldn't normally scroll around in a long list anyway. I would type the first letters and expect to jump to it. That still doesn't work. Or page up/down. Not sure if that has been mentioned.

 

[Marco Kalter]

Thanks. We'll address these things in an upcoming build.

 

[Łukasz]

On Ubuntu fetching object still takes a long time. At least few seconds.
And Ubuntu few times shows info about not responding app.

 

[Marco Kalter]

This has been fixed for the next Alpha. I will post a test-build for Windows here later today.

 

[Marco Kalter]

This latest test version for Windows should address all performance issues:

64 bit:https://www.allroundautomations.com/files/plyxon-0.9.3.537a-win64.msi
32 bit:https://www.allroundautomations.com/files/plyxon-0.9.3.537a-win32.msi

Let me know your findings!

 

[guttormvik]

With the latest windows build, scrolling around in the object browser by dragging the scrollbar or doing page up/down is smooth.
Scrolling with mouse scrollwheel is smooth, but slow.. Looks like you scroll 1 line per tick of the scrollwheel.
When I test this in other apps, they scroll 3 lines per tick. Googling, this is apparently a configurable setting in Control Panel -> Mouse -> "Choose how many lines to scroll each time". I have "3"

Filtering + unfiltering after I've opened all levels (~4000 entries) both take a respectable 3s.

I notice that page up/down now works. Nice.
However, I can not use left-arrow to move to the parent

I notice that the File List component behaves differently; It it scrolls 9 lines per tick, and left-arrow moves to the parent entry. If I have lots of things open and flick the scroll wheel, there are short freezes.

 

[Marco Kalter]

We'll take a look at the mouse scrolling and the left-arrow issue.

Only the Object List and Code Contents have been improved in this build. The File List is indeed still unchanged, and will be enhanced in an upcoming release.

 

[Marco Kalter]

We have just released Alpha 5 with this performance improvement and other features.