Subject Slow startup of database in FB 1.52
Author r.hornstra
When attaching to a Firebird database for the first time the database
takes quite a long time to get online.

The time seems to be lineair to the size of the fdb file. It cannot be
the problem that *a lot* of DDL is present. Most databases we have use
blobs extensively and are generally very simpe in structure (just a
few tables, triggers and SPs.

An example is a database of 124MB is size with 3 tables, approx 900
records in the largest table (containing PNG file blobs). It takes
10sec to get online the first time. As long as a single connection
stays alive will all subsequent attachments connect within a very
small time.

Using Firebird 1.52 SS, and FB 1.52Emb (and also tested with FB 2.0B1 SS).

Is there something that can be done to speedup the first time?