Thanks Helen !

There a fix for that I must do ?

I've done the test with no script against databases only open and close,result
is no error but

PF grows from 390 Mb to 1.27 Gb

Thanks.





________________________________
From: Helen Borrie <helebor@...>
To: firebird-support@yahoogroups.com
Sent: Mon, May 16, 2011 11:17:04 AM
Subject: Re: [firebird-support] Internal gds software consistency check(cannot
start thread)


At 07:05 PM 16/05/2011, you wrote:

>Hi Mario and thanks for your answer!
>There is a optimal value for this ? What is the MIN I should set to avoid other

>problems,this time there is such a line : #DefaultDbCachePages = 2048
>What I don't understand is why FB is acting this way as long I create a single
>connection one time,I run scrips then closing the connection,then the same with

>next fdb file

Don't forget, a "fdb file" is a receptacle for a database, not simply a file
that you write something in.


The SS cache is for *each* database, not for all connections to all databases.

"Closing the connection" doesn't necessarily close the database, either, since
the engine will still be busy completing the work requested by your DDL script
and possibly taking the opportunity to do some garbage collection.


So your Firebird server is using a lot of resources that you didn't think it
ought to because, in your mind, all these databases are just a collection of
files.

106 databases on one 32-bit XP box with 2GB RAM...and the server actually
survives until you have 90 of them open...that's pretty amazing! ;-)


./heLen




[Non-text portions of this message have been removed]