> >I was under the impression that triggers and stored procedures
> >automatically run in their own transactions and that they either fully
> >complete or give an error and roll back.
>
> No. Triggers and SPs run in the transaction that called them. If

the transaction doesn't finish for any reason then the work done by
triggers and SPs remains unfinished. The work is committed if the
transaction commits and is rolled back if the transaction rolls back.

>

Would it be correct then to say that all calls to the DB from my app
should always be made within a transaction which I explicitly declare?

Can garbage collection be done by running a command, or can it only be
done by restoring the DB?

> This looks perfectly reasonable for a database that is three weeks

old. Is it slow and/or crashing at the moment? How many users were
logged in when you took these stats? What were they doing?

No the Db is performing Ok at the moment. Probably about 7 users were
logged in, mainly reading.

> Are you using Delphi applications?

I'm using Delphi 2006 & IBObjects TIBO components (v4.8.7).

Perhaps I should write an idiots guide for people like me... :)