Subject Re: [firebird-support] Multithreading expiriences with IBPP and FB
Author Dan Wilson
> I hope anyone had some multithreading expiriences with IBPP.
> Currently I'm testing IBO in a MT environment and it works pretty well.
> I need to replace it with IBPP. So .. does anyone have any real
> expiriences with MT+IBPP?
>

Yes. Use a separate connection (which implies separate transaction, statement, etc. ) for each thread, and it works great.
Also, don't try to use local connection, use TCP/IP when using multiple connections. (I don't understand the failings of local connections: they always seemed to work fine for me, but the consensus opinion I have read here is that there are problems using them, so I've switched to TCP/IP and localhost when working from the same machine as the database server).

HTH,

Dan.