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
