Hello,
We have some huge tables (~ 3.000.000, ~100.000). I have created joined
view on indexes, but, anyway , when first accesing filtered VIEW there
appear huge delays (something like 20-60 secs). (for ex: select from
VIEW1 where mydate <'2005.01.01' )
On next time with that selection there are normal filtering delays
something like 1-0.5 secs.
I understand, that FB caches dataset, but it would be nice to optimize
that caching to maximum.
As far as I understand params affecting this are
DefaultDbCachePages,SortMemBlockSize ,SortMemUpperLimit , and Server type.
I have tried to tune those params, but results always are more or less
the same.
Maybe someone faced same problem and could help out with params settings ?

Adomas