Subject IB_Connection.Connect taking 6 hours
Author Tobias Giesen

I didn't get any reply on the firebird-support list, so I am asking
for help around here now!

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, in one case, the command


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.