Subject | Read-only versus read-write Connections |
---|---|
Author | Robert DiFalco |
Post date | 2003-10-24T19:58:20Z |
[more appropriate for firebird-support, was originally in firebird-java]
Is there any performance (i.e. non-integrity) reasons for using a
read-only connection when only reading data in NON-autocommit mode? I
certainly haven't been able to perceive any performance difference. I
notice some literature says that a database may be able to optimize a
transaction if all the operations are read-only, but I don't know if
this is really the case in Firebird or if the savings is significant.
R.
Is there any performance (i.e. non-integrity) reasons for using a
read-only connection when only reading data in NON-autocommit mode? I
certainly haven't been able to perceive any performance difference. I
notice some literature says that a database may be able to optimize a
transaction if all the operations are read-only, but I don't know if
this is really the case in Firebird or if the savings is significant.
R.