Subject | RE: [ib-support] Re: Assigning more than 10000 page buffers |
---|---|
Author | Pavel Cisar |
Post date | 2003-02-06T10:09:26Z |
Hi,
On 5 Feb 2003 at 12:28, Leyne, Sean wrote:
> There have not been any reports of this problem affecting Firebird v1.0.
This problem is hard to measure. The current cache management definitely
has some overhead rising with number of pages managed. The problem seems
to be related to mass insert where number of new pages is added to cache
and few buckets get very long page chains and thus are slow to traverse.
> I will be running some tests over the coming couple of weeks which will
> test this out definitively.
That would be great. But to get any significant numbers, you'll need to
transfer a lot o data in very big database.
Best regards
Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information