Is this right way to do READ UNCOMMITTED? - Laravel

Question

Is this right way to do READ UNCOMMITTED?

$cars = Cars
        ::raw('SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;')
        ->Active()->get();

Have you run it? did you get any errors? If you want to check whether it did something: maybe interesting? : [View isolation level for a query in mysql](http://stackoverflow.com/questions/5347567/view-isolation-level-for-a-query-in-mysql) — Ryan Vincent, Dec 03 '15 at 03:33

boroboris · Answer 1 · 2016-09-10T08:28:42.683

-1

You should use:

Cars::raw('SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED');

and than

$cars = Cars::all();

to get all cars for example.

edited Sep 10 '16 at 08:28

answered Apr 27 '16 at 14:36

boroboris

Hi, I am using Laravel 5.3.6, Can u help me ? – Pankaj Sep 08 '16 at 22:16
have you tried this answer? if yes, where is the problem and why it didn't work? and which sql version are you using? – boroboris Sep 09 '16 at 11:05

score -7 · Answer 2 · answered Aug 23 '16 at 22:04

-7

You should never use READ UNCOMMITTED unless you are generating random number and dont care about the data returned.

answered Aug 23 '16 at 22:04

skyde

this is counter productive and question asks oposite thing. – boroboris Sep 09 '16 at 10:54
The question is similar to "Is this right way to dereference uninitialized pointer?" It's important to first understand that this is almost never what you really want to do. – skyde Sep 22 '16 at 18:14

2 Answers2