Is it possible to change TIL without reconect a database?
Using zeos 7.2 without reconnect changing properties:
isc_tpb_concurrency, isc_tpb_nowait, isc_tpb_read, isc_tpb_write, isc_tpb_consistency, isc_tpb_read_committed, isc_tpb_rec_version
does not have any affect until disconect and reconect.
Is it allright?
Why Zeos does not have ZTransaction like others(SQLdb, Firedac,...) to change TIL(Transaction Isolation Level). One TIL to read data and other for updates.
change TIL(Transaction Isolation Level) without disconect, is it possible?
Re: change TIL(Transaction Isolation Level) without disconect, is it possible?
Zeos 8 includes the TZTransaction object for this exact purpose I suppose :)
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
Re: change TIL(Transaction Isolation Level) without disconect, is it possible?
Hi hamacker,
Write(in your article) that you are talking about ZEOS 7.2.14, not ZEOS 8, which has some improvements.
These include additional components: ZTransaction, ZMemTable, server name unification,
ODBC and OLEDB protocols, and an overall increase in convenience and performance.
After all, where to get the most up-to-date versions of both, i.e .:
viewtopic.php?f=3&t=143817
Michał
Write(in your article) that you are talking about ZEOS 7.2.14, not ZEOS 8, which has some improvements.
These include additional components: ZTransaction, ZMemTable, server name unification,
ODBC and OLEDB protocols, and an overall increase in convenience and performance.
After all, where to get the most up-to-date versions of both, i.e .:
viewtopic.php?f=3&t=143817
Michał
Re: change TIL(Transaction Isolation Level) without disconect, is it possible?
Hi Michael,
Well, I fix some improvements in my article to serve both versions.
In the future, I will translate to english.
Well, I fix some improvements in my article to serve both versions.
In the future, I will translate to english.