undefined | Better HN

0 pointsIzkata3y ago0 comments

One example: MySQL table locks. The application can do in parallel what the database can't.

0 comments

jve3y ago

Locks ensure you get committed data back and not some data that is in-operation and may or may not end being persisted. If you don't care about it: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;

And SQL can do parallel operations too.

j / k navigate · click thread line to collapse

0 pointsIzkata3y ago0 comments

One example: MySQL table locks. The application can do in parallel what the database can't.

0 comments

jve3y ago

Locks ensure you get committed data back and not some data that is in-operation and may or may not end being persisted. If you don't care about it: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;

And SQL can do parallel operations too.

j / k navigate · click thread line to collapse