Hi all,

I run a test on a small database, around 128MB using Firebird 2.5 64 bit superserver and the test condition is like these :

1) Put database completely on RAM, set DefaultDbCachePages = 2048 and
FileSystemCacheThreshold = 0
2) Put database completely on disk, set DefaultDbCachePages = 2048 and
FileSystemCacheThreshold = 0
3) Put database completely on RAM, set DefaultDbCachePages = 2048 and
FileSystemCacheThreshold = 65536
4) Put database completely on disk, set DefaultDbCachePages = 2048 and
FileSystemCacheThreshold = 65536


I do some extensive select sql on this database, time to finished on each conditions are :
1) +/- 37 sec
2) unknown since it seems took a very long time that I must ended with task manager
3) +/- 6 sec
4) +/- 6 sec

From those result, I don't understand why result from test condition 1 (which is, database completely on RAM) is slower than condition 3 and 4.

Isn't test condition 1,3 & 4, all running on RAM?

Thanks and regards,
Sugi