Hello, Thomas! Saturday, March 3, 2012, 12:27:42 AM, you wrote:
TS> got a few gstat outputs for test purposes and in a few cases, I saw that TS> the sweep interval was not part of the output at all. For example: TS> Is this expected? I thought if it is 0, than at least it shows up with 0 TS> in the output. TS> The only pattern I can see in the various outputs is, that this never TS> happened for databases on Windows, but occasionally for databases on Linux. The trick is that for new database default sweep interval value is not stored by Firebird. If it does not exist in header page, Firebird uses default 20000 value, thus, everything is ok. But, when you change sweep interval, it becomes in header page, so, gstat shows it. Otherwise, since value not exist, gstat does not show it. I can't say is this Firebird code invention or not, but I found it myself several years ago wrighting IBAnalyst. I also spoke about this to Dmitry Yemanov, but maybe I was too lazy to create record at FB Tracker. :-) Anyway, I wrote code that simulates Firebird behavior - if sweep interval does not exists, than it's value is default 20000. -- Dmitry Kuzmenko, www.ibase.ru, (495) 953-13-34 ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
