My website is mostly informative,
Delete, they can perform
Insert but that almost doesn't happen.
Most of the site uses
SELECT queries and the information doesn't change often so I don't mind of if user reads information that was published even a day ago.
Now the isolation level is the default which is
Read Committed which seems a bit overkill for my website I think.
After a bit research I think about changing it to
What do you suggest?