LO Base interface lagging with many controls

[andfro]

I have a Base form connected to a Firebird 3 embedded database via JDBC, which contains a lot of UI elements, mainly numeric controls and listboxes.

The form is ordered in subforms according to the image below.

The form is displayed in Normal view and is stretched over multiple pages. It works fine when I scroll through the other pages but on this page (which has the most UI elements) the UI starts lagging uncontrollably. Lagging stops when I get past this page. I have been able to reproduce the issue by creating an empty form and adding controls until the lagging starts.

I am on Win10, i7 processor with 16 GB RAM.

I have tried the following without success:

• All combinations of Skia/Anti-aliasing/hardware acceleration on and off
• Multiple computers
• Java 8 and 11 runtime
• LO7.0, 7.1, 7.2
• List item
• Increasing memory through Expert configuration

Are there more options I can try to make the UI smoother during scolling?

[gkick]

Hi,

heaps of listboxes can slow things, you can try to populate the boxes with views instead of queries or sql

[Ratslinger]

Hello,

Just a note. You cannot use JDBC with Firebird embedded. Access is only done through the LO internal mechanism - SDBC (native connection).