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.