IsolationLevel
No edit summary
(Automatically adding template at the end of the page.)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel?view=net-6.0 https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel]
This is how a database tells how isolated a task is from other tasks in the database. See: [https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel?view=net-6.0 https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel]
 
This is how a database tells how isolated a task is from other tasks in the database.


In MDriven, set in SqlDatabaseConfig one isolation level for update UpdateIsolationLevel and one for read FetchIsolationLevel.
In MDriven, set in SqlDatabaseConfig one isolation level for update UpdateIsolationLevel and one for read FetchIsolationLevel.


If you have too low a UpdateIsolationLevel extraction of new IDs and timestamps, it may not be unique and cause problems with your data integrity.
If you have too low a UpdateIsolationLevel extraction of new IDs and timestamps, it may not be unique and cause problems with your data integrity.  
[[Category:Database]]
[[Category:Database]]
{{Edited|July|12|2024}}

Latest revision as of 15:35, 10 February 2024

This is how a database tells how isolated a task is from other tasks in the database. See: https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel

In MDriven, set in SqlDatabaseConfig one isolation level for update UpdateIsolationLevel and one for read FetchIsolationLevel.

If you have too low a UpdateIsolationLevel extraction of new IDs and timestamps, it may not be unique and cause problems with your data integrity.

This page was edited 98 days ago on 02/10/2024. What links here