It looks like database creation in Firebird 4 is slower (about 50%)
compared to 3.0.4. On my system, creating a database in Firebird 3.0.4
(through org.firebirdsql.management.FBManager) takes roughly 200ms,
while on Firebird 4.0.0.1352 it takes roughly 300ms.
Is this primarily due to increased size of metadata, or has something
else changed that slows this down?
This may seem trivial ('Who creates a lot of databases?' Well, I do):
running Jaybird's tests creates a lot of databases, so a decrease in
performance there is very noticeable for me.
The Jaybird pure-java testsuite on 3.0.4 takes +/- 6 minutes, against 4
it takes +/- 10 minutes (although that also includes extra tests for
features not in Firebird 3). The testsuite consists of almost 5000
tests, which leads to the creation of - at a guess - 1500 to 2000
databases (some tests don't need a database, and some tests share a
database).
To be clear, I'm only asking if this is an unexpected performance
regression, or if it is something that is expected with no room for
improvement.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
