On 18 Aug 2004 at 8:28, blahclayton wrote:

>or can I do some statement initialisation on startup and cleanup on
>killing the thread?

Prepared statement stay prepared even if transaction has been
commited.

>Will this work with more than one statement being called?
>
>Also, Do I need to do a commit_transaction on selects?

It depends on transaction's parameters. RepeatebleRead transactions
apparently have to be commited to see fresh changes of data.

SY, Dimitry Sibiryakov.