Subject gbak-restored database is Extremely Slow on queries in Firebird 2.0
Author Jay
I'm using Firebird 2.0 RC5 Classic on Ubuntu 6.06.
I have a database loaded with dummy records that I
load up from a C++ program. After the data is loaded
(about 1/4 million records) I can perform queries with
a performance of about <= 1 second.
However, after using gbak to backup and then restore
the database, those same queries run at about 40 to
greater than 60 seconds!
Is there anything I'm missing that _should_ be done
after a restore?
Can anyone please offer some suggestions? I can
provide more info if needed. I'm pretty much a novice
with Firebird so I'm not very familiar with database
profiling techniques.


Low, Low, Low Rates! Check out Yahoo! Messenger's cheap PC-to-Phone call rates