current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Got a 350 GB database (more than 40M records plus 0 - 1000 BLOBs for each record in another table). After upgrading Firebird to version 2.1.5 (mainly because of filesystem cache issue) database became terribly slow, both insertion and fetching. How to restore performance? I tried running some queries to force caching, it was somewhat helpful, and currently left it with gbak running, but what's the"proper" way?

UPDATE:
Everything went back to normal in 24 hours or so, but the question is still relevant.

share|improve this question
    
Probably should stick to 2.1.3 - it wasn't that bad after all, since they were able to store and query all that data :) –  Sergei Ousynin Jun 4 '13 at 19:04
    
Did you by any chance upgrade from 32 bit to 64 bit? –  Mark Rotteveel Jun 6 '13 at 14:43
    
Nope, 32 bit in both cases. –  Sergei Ousynin Jun 10 '13 at 12:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.