14.11.2016 16:09, Thomas Steinmaurer wrote: > 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)
Here you disabled file system cache (as Denis already said) >>> 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? SS requires less support from file system cache for reads but still need it for writes, especially in OLTP environment. The best case when current Firebird could work better without support of file system cache is when: - mostly read load - working set fits into page cache - database page cache is preloaded (using "select count(*)" for example) Regards, Vlad ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
