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