Subject Multi-threading & database size limit ?
Author benedicte_asselin

I am evaluating Firebird, I want to be able to run several
concurrent transactions within the same process (one transaction per
thread ?). I also plan to insert quite big BLOBs into the database
(several MB or tens of MB would be possible), this would lead to
very big database file.
Can I do multi-threading using the embedded version of firebird ?
Is there a theoretical limit for a unique file ? will I have to make
several files to have a database bigger than say 2GB or something
like that ?

I tried to search the doc but was quite confused.
Please help