Bug 164032 - Base : scrolling in table display very low
Summary: Base : scrolling in table display very low
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Scrolling-PageUpDown
  Show dependency treegraph
 
Reported: 2024-11-24 19:51 UTC by moebius20
Modified: 2025-10-16 12:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description moebius20 2024-11-24 19:51:59 UTC
Description:
When displaying a small table in base 180 records and 30 rows, scrolling through the rows or the fields is very very very slow : more than 20 seconds after clicking on an arrow before window content move

Steps to Reproduce:
1.Just opening a table display by double-click on a table ; then try to scroll
2.
3.

Actual Results:
Scroll very very very slow

Expected Results:
normal scroll without delay


Reproducible: Always


User Profile Reset: Yes

Additional Info:
It's a long time bug (many years) ; when resetting user profile, the behavior become a little better but clicking on a lift to move it is not an option because it doesn't work, the lift stay in place.
Comment 1 Robert Großkopf 2024-11-25 10:08:27 UTC
With a table of 180 records and 30 columns (not rows, as described) every database here will scroll directly. 
Tested with a internal HSQLDB and a table with 30000 records and 15 columns. Opening of table ca. 1 second, scroll down will work directly, scrolling to last row directly about 5 seconds.
Tested on OpenSUSE 15.6 64bit rpm Linux, 
Libreoffice
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Which system do you use?
Which database type? Internal HSQLDB or internal Firebird?
If you are using HSQLDB or JDBC: Which version of Java did you install?
Comment 2 moebius20 2024-11-25 12:15:07 UTC
Bonjour,
Thank youi for your interest.
I use debian bookworm.
For the database type, I really don't know where to find the information, I've never done something special... but it's a very old database, perhaps more than fifteen years so I don't remember the type.
Java is openjdk-17-jre
Cordialement,



(In reply to Robert Großkopf from comment #1)
> With a table of 180 records and 30 columns (not rows, as described) every
> database here will scroll directly. 
> Tested with a internal HSQLDB and a table with 30000 records and 15 columns.
> Opening of table ca. 1 second, scroll down will work directly, scrolling to
> last row directly about 5 seconds.
> Tested on OpenSUSE 15.6 64bit rpm Linux, 
> Libreoffice
> Version: 24.8.3.2 (X86_64) / LibreOffice Community
> Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
> CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
> Locale: de-DE (de_DE.UTF-8); UI: de-DE
> Calc: threaded
> 
> Which system do you use?
> Which database type? Internal HSQLDB or internal Firebird?
> If you are using HSQLDB or JDBC: Which version of Java did you install?
Comment 3 Buovjaga 2025-10-14 19:41:06 UTC
Would it be possible to share an example database, so we can test? I understand it can be annoying to anonymise, but without a concrete example there is not much we can do to help.
Comment 4 Robert Großkopf 2025-10-15 05:54:39 UTC
For database type: If you open the database it will be shown at the bottom of the window as "statusbar". Might be embedded database, HSQLDB.

Behavior of this database depends on Java. Have seen it very slow in the past with some Java versions, but with openjdk 11.0.28 I couldn't see any problem here.
Comment 5 moebius20 2025-10-15 07:07:53 UTC
Bonjour,
You're right, it's HSQLBD and openjdk is 21.0.9-ea version. My computer run debian testing with 64 bit intel processor.
Unfortunately, the bug is always present but scrolling is a little bit less slow ; for chance, I don't often use table view.
In fact, I notice it depends of database.
In one the main table scroll quickly and the other one, main table have problems ; the one with problems own a lot of boolean columns (17) but only 130 records.
No boolean column for the one where everything is ok but it contains almost a thousand records. Could it be the great number of boolean columns the problem ? It would be strange, but...
These two tables are HSQLBD ;  and I never were asked by libreoffice to change for firebird.
cordialement,
Comment 6 Buovjaga 2025-10-15 16:11:33 UTC
Hmm, now it occurred to me that you might see a certain Linux + Wayland bug. Please copy and paste here the content of your Help - About by clicking the copy button. This allows us to know more about your system.
Comment 7 moebius20 2025-10-15 16:53:49 UTC
OK, here it is :

Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 8; OS: Linux 6.16; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

cordialement,
Comment 8 Buovjaga 2025-10-15 16:58:46 UTC
(In reply to moebius20 from comment #7)
> OK, here it is :
> 
> Version: 25.2.6.2 (X86_64) / LibreOffice Community
> Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
> CPU threads: 8; OS: Linux 6.16; UI render: default; VCL: gtk3
> Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
> Calc: threaded
> 
> cordialement,

Ok, gtk3 instead of kf6, so it's not what I suspected. No chance to attach an example file that shows the issue?