Re: [firebird-support] Re: FB3 Memory usage

2016-11-07 Thread Si Carter s1car...@gmail.com [firebird-support]
Hi Dmitry, Take your point on there being no orphaned records, default for TempCacheLimit is 8 MB (see below dragged from conf file). And proof in terms of screen shots are below. You may also see on there FB2.5 which has many more websites on it. fwiw, I am just trying to understand why the

[firebird-support] Re: FB3 Memory usage

2016-11-06 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
04.11.2016 13:30, Si Carter wrote: > The memory usage crept up to just under 3gb again Once again, where do you get that number from? Task manager? Perfmon? top? Screenshot proof would be appreciated. > The memory usage crept up to just under 3gb again, and I took a snapshot > of the data

Re: [firebird-support] Re: FB3 Memory usage

2016-11-04 Thread Si Carter s1car...@gmail.com [firebird-support]
The memory usage crept up to just under 3gb again, and I took a snapshot of the data using the previous sql, from all 4 databases. Between the 4 databases there are over 1500 orphaned records, and between the 4 databases there are 30 identifiable connections. I have placed the raw data in a csv

Re: [firebird-support] Re: FB3 Memory usage

2016-11-04 Thread Si Carter s1car...@gmail.com [firebird-support]
Fair point, I only took a snapshot of the "orphaned" stats from one of the databases, if it happens again, will gather all data for all databases. But as far as your concerned it's normal to have orphaned records within there? regards Si On 3 November 2016 at 15:47, Dmitry Yemanov

[firebird-support] Re: FB3 Memory usage

2016-11-03 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
03.11.2016 09:37, Si Carter wrote: > > I recently installed FB v3.0.1.32609 on Windows server 2008. > > This is a dual installation as I still have 2.5.3 installed. > > I noticed that my fb3 service is using in excess of 4gb memory How did you get that number? > Given this sql > > SELECT