Hello,

I am using Firebird 2.5.0 Embedded with IBObjects.

One of my customers has a pretty extreme use case for my application.

The EXE is invoked maybe around 1000 times per day. Every time it opens
and closes one of several Firebird databases. Several instances of the
program can run in parallel, but each will use a separate database.

Maybe once in a few days, there is a delay opening the database.

For example, yesterday, the command

dmIBODatabase.IB_Connection.Connect;

took 6 hours. The database size in this case was 386MB and the main
table contains 688654 rows.

What could cause such a delay and how can I avoid it?

Thanks for any tips.

Cheers,
Tobias
www.superflexible.com