This happened under 7.5.7.1 but also under 7.6.6.3. a database was copied from a Windows 10 computer with less powerful hardware (hard disc among others) to a more powerful Windows 11 computer (ssd disk). While the initial loading was accelarated considerably from north of 30 seconds to 5 seconds (as I expected) scrolling through the data with page up or page down is now completely useless. On the older machine it took roughly 10 seconds to scroll through 10.000 lines of data while on the new one (for the identixcal selection) every single page (40 lines of data) takes almost two seconds. Nothing like that happens when scrollinig through calc documents with a large number of lines but the selections in base are behaving completely different and are almost unusable this way.
Which kind of database do you use? Internal HSQLDB? So please have a look at the Java engine you have installed.
Sorry for not mentioning this, I am using Firebird. HSQLDB was visibly slower in the past when I tried Firebird and compared them so I am sticking with Firebird. No Java installed since I don't need it for Firebird.
Have tested this some times ago on OpenSUSE Linux and wrote it in Base Handbuch: Table with 30000 rows 1 second scrolling down with Firebird 30 seconds scrolling down with HSQLDB. Don't know what is going wrong here with you database under Windows. You could send the database per private mail for testing. Think the content should be for public use…
Created attachment 193703 [details] Firebird database with one table, 30000 rows - old testing database of another bug See the Firebird example database. Scrolling here without any problem through the table. Jumping to last row won't need a second under OpenSUSE 15.6 64bit rpm Linux and LO 24.2.2.2
Well, I am not scrolling through a table but a select (Don't know which English term is shown in Base. In German it is "Abfrage" and they are situated between tables and forms). The selection joins a couple of other tables and it has roundabout 155,000 values. That said, getting to the end (with the corresponding button) is no problem. That happens within less than ten seconds but pushing page down (or rather keeping it pushed) is the problem. On the old system the pages changed so fast you could hardly read anything and on the faster new system there is an almost 2 second lag between every page. The whole database is 11.6 MB. If my e-mail doesnt't prevent that amount from being sent I could send it to ...?
Got a solution per private mail: Its a rendering problem. When disabling Skia scrolling seems to be no problem. I will set this one to WORKSFORME.