Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

14.11.2016 21:26, Thomas Steinmaurer пишет: >> >>> But still, IMHO it does not explain why additional connect request with >>> SS while running OLTP emul with 100 users are taking considerable time, >>> although they are almost instant with SC? >> >>This is not SS vs SC. This is absence vs

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

> 14.11.2016 21:00, Thomas Steinmaurer wrote: > >> But still, IMHO it does not explain why additional connect request with >> SS while running OLTP emul with 100 users are taking considerable time, >> although they are almost instant with SC? > >This is not SS vs SC. This is absence vs

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

14.11.2016 21:00, Thomas Steinmaurer wrote: > But still, IMHO it does not explain why additional connect request with > SS while running OLTP emul with 100 users are taking considerable time, > although they are almost instant with SC? This is not SS vs SC. This is absence vs presence of

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

Hi Vlad, > 14.11.2016 20:27, Thomas Steinmaurer wrote: > ... >> So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still >> recommended with Firebird 3 SS and the shared page cache, to rather use >> a smaller number, lets say 50K and keep the FileSystemCacheThreshold at >> 64K to have

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

14.11.2016 20:27, Thomas Steinmaurer wrote: ... > So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still > recommended with Firebird 3 SS and the shared page cache, to rather use > a smaller number, lets say 50K and keep the FileSystemCacheThreshold at > 64K to have the file system

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

Hello Vlad, > 14.11.2016 16:09, Thomas Steinmaurer wrote: >> Hello Simon, >> >>> Thomas Steinmaurer 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

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

14.11.2016 16:09, Thomas Steinmaurer wrote: > Hello Simon, > >> Thomas Steinmaurer 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

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

Hello Simon, > Thomas Steinmaurer 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

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

Thomas Steinmaurer 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

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

Hi, > 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

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

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) >

[Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

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