> 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?

A VERY wild guess is that too much page buffers are allocated as 2.5
Embedded is now based on SuperClassic and not SuperServer any more, thus
allocating too much RAM getting into swap to disk scenarios, but I can't
believe this results in a 6h connect time. ;-)



--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/