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). When running oltp-emul with 100 concurrent users (only) by: 1run_oltp_emul.bat 30 100 I see Firebird server CPU usage < 4% only and IO < 3MB/s all the time, thus mainly random I/O bound, I guess, without having a proof, thus could also be code related. What's weird is that e.g. additional attachment requests, e.g. via isql may take > 10s then. This does not make sense and makes SS entirely unusable. I haven't tried SC or CS under that scenario yet. Anything known in that area? Thanks, 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
