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

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

Win2003 Pro Server AMD64 3000+,1GB RAM
Database in one file (not in *.gdb :)).Size ~ 3Gb.
App access via IBO, testing via EMS IBManager, DB Workbench.

>Adomas Urbanavicius wrote:
>>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 ?