Subject Odp: [firebird-support] Big database optimizatio n

What kind of server Superserver or classic or superclassic
And how big is that cache settings?

Karol Bieniaszewski

----- Reply message -----
Od: "zilez2003@... [firebird-support]" <>
Do: <>
Temat: [firebird-support] Big database optimization
Data: czw., sty 8, 2015 22:22


I am runing WI-V2.5.2.26539 Firebird 2.5, on win 7 64 bit. Databse is more than 20 GB big, and I have tables which are really huge - millions of rows.

My query combines 6-7 tables, and all tables are searched with use of indexes, so altough tables are huge, query fethes only 10.000 rows, for example. So far so good. The issue I have is that if I run query firs time, it is very slow, even when using queries. Than , second time, cash is doing its, and query becomes fast. But than, when I change parameters for the query, again it is slow.

I tried with really bigger database cache - no improvement, only slower result.

Any advices, or links to some info articles ?