Hello Simon, > Thomas Steinmaurer <t...@iblogmanager.com> wrote Mon, 14 Nov 2016 15:03:41 > +0300: > >> Hello, >> >> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >> >> Performance related changes in firebird.conf are: >> >> DB Page Size = 8K >> DefaultDbCachePages = 128K (DB specific page buffers = 0) >> TempCacheLimit = 1024M >> LockHashSlots = 22111 >> >> anything else is default (except TCP port). >> > > Try to install FileSystemCacheThreshold > DefaultDbCachePages. > If FileSystemCacheThreshold < DefaultDbCachePages file cache is disabled, > which may reduce performance ability to make some cases.
From my understanding, file system cache is much more important for SC/CS than with a large single page cache in SS. Is this assumption wrong? Thomas ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel