> I have a Firebird 1.5 DB with 50+ tabels with no dependencies (i.e.
> the dependencies are resolved in my C# code).
> What I would like to know is, how does Firebird lock tables when I
> commit an update or insert into a table?
> Is nothing locked, is the table in question locked, is the entire DB
> locked or only tabels with dependencies made in Firebird via an EMS?
>
>

nothing is locked. Firebird is multi-generational. A new version of the
record is created on update and is not visible to concurrent transactions
until the transaction in qestion is committed.
We don't lock anything by default.
Alan