0
 Followers
2
 Likes

Read Committed for SQL Server

Database
On our radar

I hope the isolation level of SQL Server is changed to Read Committed. Or selectable it is also glad.
https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Data/Database_Reference/Handling_Transactions#Isolation_Levels

Created on 25 Oct 2018
Comments (5)

Changed the category to Database


Changed the status to
On our radar


Hi Takasi,

First of all, let me thank you for your contribution.

Can you elaborate why do you need to change the SQL server isolation level to other than what is used by the platform? What is your use case for that?

Thank you

Thank you for comment.

In case of SQL Server, during Timer action updating entity data over time, the updating data are viewable for app users.  When customer doesn't want this behavior (only committed data must be available), he has to choose Oracle.  Even if he is more familiar to SQL Server than Oracle.
Additionally, if customer has to build his environment as on-premise, Oracle's license is more expensive than SQL Server in most situations.

For me, when the behaviors of Oracle and SQL Server are same, it is easy to explain to customers.

Thank you Takasi!

Are those requirements frequent in your organization?

In terms of where that data is stored, and focusing on your use case, those entities are from the OutSystems database or from an external database? 

Hello Tiago,

Are those requirements frequent in your organization?

Not frequent as of now.

In terms of where that data is stored, and focusing on your use case, those entities are from the OutSystems database or from an external database? 

From the OutSystems database.

views
149
Followers
0