About TempCacheLimit Configuration

[Luciano Rodrigues Nunes Mendes]

Hi everyone,

I have a question regarding the TempCacheLimit configuration parameter. I'm using SuperServer and reading the documentation didn't make it clear to me whether the TempCacheLimit value defined in firebird.conf is for each database (as happens with the DefaultDbCachePages parameter) or if the value defined by TempCacheLimit in firebird.conf is shared for all databases managed by Firebird.

Thanks in advance,

Luciano

[Mark Rotteveel]

On 07-06-2026 04:15, Luciano Rodrigues Nunes Mendes wrote:
> Hi everyone,
>
> I have a question regarding the TempCacheLimit configuration parameter.

> I'm using SuperServer and reading the documentation <https://
> www.firebirdsql.org/docs/html/en/refdocs/fbconf/firebird-configuration-
> reference.html#fbconf-temp-cache-limit> didn't make it clear to me

> whether the TempCacheLimit value defined in firebird.conf is for each
> database (as happens with the DefaultDbCachePages parameter) or if the
> value defined by TempCacheLimit in firebird.conf is shared for all
> databases managed by Firebird.

TempCacheLimit is per-database configurable, so the setting, even in
firebird.conf, is a limit per database. The configuration value in
firebird.conf is used as the default value if it isn't overridden in
databases.conf for a database.

I'll see if I can update the docs to make this more explicit.

Mark
--
Mark Rotteveel

[Luciano Rodrigues Nunes Mendes]

Thank you very much for your quick reply, Mark!

Now it makes sense why the Firebird process is consuming so much memory on my server: I set TempCacheLimit = 256M and Firebird is consuming 800M more than expected (I thought that 256M was shared among all databases).

Best Regards,

Luciano

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/acda1a82-6e55-4fae-a226-ddf282933c0d%40lawinegevaar.nl.