Dmitry Yemanov <firebi...@yandex.ru> писал(а) в своём письме Thu, 05 Jun 2014 11:22:28 +0400:
> All, > In FB3, we have increased the default page cache size for Classic > (SharedCache = false) from 75 to 256 pages. I'd like to propose other > changes as well: > 1) Bump the default page cache size for SuperServer (SharedCache = true) > from 2K to at least 8K pages. Personally, I'd go for ~20K pages. Agreed. 8K is just right as the default value. If you need more will exhibit themselves. 20K * 8K = 160M it can significantly increase the amount of memory consumed for embeded mode. > 2) Rename DefaultDbCachePages config setting to something like > PageCacheSize, as "default-db-something" setting looks weird in the > customized per-database configuration. So of course logical. > 3) Bump the default page size from 4KB to 8KB, i.e. choose the > compromise value (min is 4K, max is 16K) as default. Databases tend > getting bigger and we often recommend moving higher from 4KB pages. Agreed. -- Simonov Denis ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
