At 07:46 PM 11/7/2004, Chad Z. Hower aka Kudzu wrote:

>isc_tpb_read Read-only access mode that allows a transaction only to select
>data from Tables
>
>What is the exact significance of this? Does it just stop me from performing
>updates and throw an exception?

Yes.

>Or if I am only doing reads, does it have
>performance or memory benefits?

Yes, especially if you're running a read_committed transaction. A
read_committed, read_only transaction is "pre-committed" so it has
no effect on the concurrency problems of other transactions.

Regards,


Ann