Subject Re: [firebird-support] FIRST SELECT HUGE DELAY : OPTIMIZATION
Author Lester Caine
Adomas Urbanavicius wrote:

> 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 ?

You will have to supply a few more details.
Version of OS
Accessing method
Some machine details

Lester Caine
L.S.Caine Electronic Services