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