Please download this database and open the form called “bed_plants”. For me it is painfully slow to change records and delete records. I wonder why and what I can do to speed it up.
LO 25.8 takes 4 or 5 seconds to change records.
LO 7.8 takes 3 or 4 seconds to change records.
You are using external HSQLDB. So might be it is the JRE, which slows down the database. Had tested this sometimes ago: Scrolling to the end of a table with internal HSQLDB was 30 seconds, while internal Firebird does the job in 1 second. You haven’t written which Java version you have installed.
You are running Linux with some GTK environment, right?
Start LibreOffice like this:
SAL_USE_VCLPLUGIN=gen libreoffice25.8
and everything will be fine.
1 Like
I know nothing about your installation. I guessed your OS from the symptoms.
Usually, LibreOffice is started by a shell script /opt/libreoffice25.8/program/soffice.
Make a backup copy of the start script (as root):
cd /opt/libreoffice25.8/program/
cp soffice soffice.bkp
Insert the following line below #!/bin/sh
if [ -z "$SAL_USE_VCLPLUGIN" ];then SAL_USE_VCLPLUGIN=gen;fi export SAL_USE_VCLPLUGIN
This will start the office with the generic toolkit unless you specify another one.
Save the file and make a backup of that version too:
cp soffice soffice.gen
After the next upgrade your script will be overwritten:
cp soffice soffice.bkp
cp soffice.gen soffice