Subject | Slow startup of database in FB 1.52 |
---|---|
Author | r.hornstra |
Post date | 2006-01-18T10:01:25Z |
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?
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?