> > That's quite a number, when running in 24x7 mode! Although due to the > example above, it seems you do explicit transaction management. So, > either you still use automcommit somewhere, which results in a new > transaction for every piece of work, our you have a lot of connections > and work to be done by explicit transactions. > > I really think that you are using autocommit as well. The least > expensive transactions are READ COMMIT READ ONLY, so basically make use > of at least read-only transactions, when you are selecting stuff from > the database and don't write. >
not really autocommit, but i don't let any transaction open. when the code need some data, he call a global procedure that will gave him the data he need. the procedure will open (and close) an transaction each time and query the fb server. now i can open a transaction when each thead start and close it when each thead end but i always hear that transaction must be short as possible :( stéphane [Non-text portions of this message have been removed]
