Description: Base has become very very slow. It is not usable anymore. I went back to LibreOffice Version: 6.3.4.2 and evrything is back to normal. Steps to Reproduce: 1.open a form with subform in base 2.navigate through the records Actual Results: screen freezes for a few seconds, subform is not updated with the parent form Expected Results: The subform shows the records related to the parent form Reproducible: Always User Profile Reset: No Additional Info: reset of user profile didn't change anything. Changing java jre version didn't change anything.
Which DB do you use? Embedded Hsqldb? Embedded Firebird? MariadB? Postgres?
It has an Embedded Firebird. I checked in the .odb file and I found database/firebird.fbk
Is it specific to this file or does it happen on every odb file with embedded Firebird? Would it be possible you attach the file so we can give a try? (see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission) Do you reproduce this with embedded HSQLDB file? You must know that few work is done on Base because of lack of resource. Moreover, Firebird is hardly maintained.
Without a test file, we will probably not be able to reproduce. Please provide one if you can, bearing in mind that the file will become public. You mention that the ODB file contained a fbk file, but did you create this database file originally as embedded hsqldb and then migrate, or did you create from the beginning as an embedded Firebird ODB ? If you migrated, the migration assistant leaves the original copy of the hsqldb file within the ODB, I have no idea what exactly gets loaded into memory when you then open that ODB file to work on.
Created attachment 160832 [details] Base with performance trouble
Please find the file gemiddelde.odb in attachement.
I tried it with the latest version. Version: 6.4.3.2 Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU threads: 8; OS: Linux 4.4; UI render: default; VCL: x11; Locale: nl-BE (en_US.UTF-8); UI-Language: en-US Calc: threaded When libreOffice is launched from the command line : SAL_USE_VCLPLUGIN=gen libreoffice6.4 Now there is no more performance problem. I had also issues with start center (Bug 130291) and icons not showing in the menus. This is all solved when starting with the command line above. Thanks !
Thank you for your feedback. What's your usual env? GTK, KDE, other? Could you also provide version + Linux distrib?
Hello, I'm using Linux Mint 18 Cinnamon 64-bit Cinnamon version 3.0.7
(In reply to Vincent Bamps from comment #9) > Hello, > I'm using Linux Mint 18 Cinnamon 64-bit > Cinnamon version 3.0.7 Ok so the fork of Gnome. Just for curiosity, could you try this: SAL_USE_VCLPLUGIN=gtk3 ?
Starting LibreOffice with command line: SAL_USE_VCLPLUGIN=gtk3 libreoffice6.4 reproduces the issue. So, Base remains very slow and is not usable under this configuration. I switched back to LibreOffice-6.3.5.2 the last version before all the trouble. Thanks for your time.
Xisco: thought about putting NOTOURBUG (rather Mint's one), what do you think?
OK, What would be the workaround to make it work properly in Linux Mint . Thanks!