I am using Firebird 2.5 Superclassic server and the database file is 550 MB.
The table with slow updates has 456018 rows.
I must often update ~100 rows at once. ~100 updates consumes from 55 to 65 seconds. (I deactivated for testing all indexes and triggers. Also I am starting transaction at start and commit at end.)
I have another table with 17559 row, in this table is updating multiple rows very fast.
I think updates are getting slower as tables are getting bigger.
Selecting is overall very fast.
Has anyone experiences with other databases with faster updates. Can someone recommend a database with faster updates ?
What is with mysql/mariadb is there updates faster than in firebird?