Which Firebird.conf settings has most effect on Backup (or restore) speed?

18 views
Skip to first unread message

Tommi Prami

unread,
Jun 4, 2026, 1:40:12 AM (9 days ago) Jun 4
to firebird-support
Hello,

If trying to optimize the server settings, whats settings should we try first, and what would be good procedure to do so?

-tee-

Dimitry Sibiryakov

unread,
Jun 4, 2026, 3:33:18 AM (9 days ago) Jun 4
to firebird...@googlegroups.com
Tommi Prami wrote 04.06.2026 7:39:
> If trying to optimize the server settings, whats settings should we try first,
> and what would be good procedure to do so?

First of all you must find a bottleneck. Random search rarely helps.

--
WBR, SD.

Dimitry Sibiryakov

unread,
Jun 4, 2026, 3:38:13 AM (9 days ago) Jun 4
to firebird...@googlegroups.com
Tommi Prami wrote 04.06.2026 7:39:
> what would be good procedure to do so?

For backup/restore start from running gbak with `-V -ST D` options to find
the longest operations.

--
WBR, SD.

Alexey Kovyazin

unread,
Jun 4, 2026, 5:22:15 AM (9 days ago) Jun 4
to firebird...@googlegroups.com
Hello,

DefaultDbCachePages and TempCacheLimit are the most important.

Take a look

From Firebird 5, -parallel option is in vanilla Firebird.

Regard,
Alexey Kovyazin


--
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/CABwd-aqcOTdswfx9c1eqKcZZjXRcae7zqUROZ6ZVz9-3viNXrg%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages