Hi, > 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.
Re-run: 1run_oltp_emul.bat 30 100 with SuperClassic and firebird.conf changes: DefaultDbCachePages = 1024 TempCacheLimit = 8M An entirely different picture now. Although CPU usage is still < 5%, disk I/O (read+write) throughput (according to Process Explorer) is 20MB/s or even more and more importantly, additional attachment requests are instant. Looks to me like a serious lock contention bug/regression in SuperServer. 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