On Thu, 30 Oct 2003 11:56:53 +0000 (UTC), Pelle F. S. Liljendal wrote:

> For our latest project we are planning to create a "batch-server" which
> is simply a service that runs the various jobs each in a separat thread.
> As of now I am simply testing how well threaded DB access is working. I
> have written a small test application where I start several threads (e.g.
> 4 or 8) each writing 2000 (simple) records to the database. ...
>
> Regarding IBO I am using the iboTDataSet components (IBODatabase,
> IBOTransaction, IBOQuery and IBOStoredProc) inserted into a DataModule
> also containing an IB_Session (IB_Session is the first module inseted
> into this DataModule). Each thread creates an instance of this DataModule
> hence each thread "owns" a Session, Database, Transaction, Query and
> StoredProcedure.
>...

When doing inserts (or updates or deletes), the TIB_DSQL can be your best
friend.


--
Aage J.