Alexandre Benson Smith wrote:

>> The slowness is caused by "eating" more CPU power.
>> But this problem was discovered many years ago - with todays CPUs
>> you will hardly notice any difference.
>>
>>
>
> I did not know this, bu I think it is not too small nowadays, because
> the core developers will not change it if it is not applicable anymore,
> and it's emphasized on Release notes.
>

Just for info, from release notes:

Some General Improvements
O. Loa, D. Yemanov
• Much faster algorithms to process the dirty pages tree
Firebird 2.0 offers a more efficient processing of the list of modified
pages, a.k.a. the dirty pages
tree. It affects all kinds of batch data modifications performed in a
single transaction and eliminates
the known issues with performance getting slower when using a buffer
cache of >10K pages.
This change also improves the overall performance of data modifications.
• Increased maximum page cache size to 128K pages (2GB for 16K page size)


see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br