I'm restarting only my application,I've seen that closing it, fbserver.exe
decrease dramatically in memory usage.Also PF Usage goes from >1.2Gb to >500 Mb





________________________________
From: "Manzano Vázquez, Mario" <mmanzano@...>
To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Sent: Wed, May 18, 2011 9:47:35 AM
Subject: RE: [firebird-support] Internal gds software consistency check(cannot
start thread)


Do you mean autorestarting your application or firebird service?

Mario


De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
En nombre de Mr. John

Enviado el: miércoles, 18 de mayo de 2011 8:33
Para: firebird-support@yahoogroups.com
Asunto: Re: [firebird-support] Internal gds software consistency check(cannot
start thread)




I solved this problem autorestarting application after 30 connections,now it
works fine.

________________________________
From: Helen Borrie <helebor@...<mailto:helebor%40iinet.net.au>>
To: firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.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]


________________________________
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo,
contiene información de carácter confidencial exclusivamente dirigida a su
destinatario o destinatarios. Si no es vd. el destinatario indicado, queda
notificado que la lectura, utilización, divulgación y/o copia sin autorización
está prohibida en virtud de la legislación vigente. En el caso de haber recibido
este correo electrónico por error, se ruega notificar inmediatamente esta
circunstancia mediante reenvío a la dirección electrónica del remitente.

Evite imprimir este mensaje si no es estrictamente necesario.

This email and any file attached to it (when applicable) contain(s) confidential
information that is exclusively addressed to its recipient(s). If you are not
the indicated recipient, you are informed that reading, using, disseminating
and/or copying it without authorisation is forbidden in accordance with the
legislation in effect. If you have received this email by mistake, please
immediately notify the sender of the situation by resending it to their email
address.

Avoid printing this message if it is not absolutely necessary.

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




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