Hi,

At May 29, 2006, 3:35 PM, Bill Oliver wrote:

> Here's my question - While the data pages will be recylced, do the
> TIP pages ever get recycled, short of a backup/restore? And, is
> there any easy way to see how many database pages are being used to
> track old transactions?

There was a discussion, in the Firebird-Architect group, about
automatically ressetting the transaction number counter. I don't quite
remember exactly when it took place, but I know that Jim and Ann did
participate in that discussion.

> One would think that this wouldn't cause a speed slowdown anyhow,
> since those old pages would age out of the cache, but maybe there is
> something weird going on with the OS (Windows) cache?

That wouldn't be a surprise to me. I noticed today that my
development database still had the last changed timestamp as of early
this morning and it only got updated later this afternoon after I
disconnected from it. And, yes I do have foreced writes on.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)