Subject | What is the proper transaction level |
---|---|
Author | buppcpp |
Post date | 2005-06-15T09:13:29Z |
I have read that "read commited" should not be used, because it
is "broken".
I have read that I should use "snapshot".
If using snapshot is the correct choice (for possible queries that my
sit on a users display for hours), then what would be the correct
settings to use for this transaction type when using the following:
1. Firebird API
2. ODBC
3. OLEDB
I think this information written in a clear manner could help a lot of
people from getting "stuck" transactions.
Thanks
is "broken".
I have read that I should use "snapshot".
If using snapshot is the correct choice (for possible queries that my
sit on a users display for hours), then what would be the correct
settings to use for this transaction type when using the following:
1. Firebird API
2. ODBC
3. OLEDB
I think this information written in a clear manner could help a lot of
people from getting "stuck" transactions.
Thanks