Hi all ,
I have a quick question regarding table locking.
This is a snippet referring to when table locking is disadvantageous:
Another client issues another SELECT statement on the same table. Because UPDATE has
higher priority than SELECT, this SELECT will wait for the UPDATE to finish. It
Every new connection is considered a client. It's a bad idea to try to
do your own scheduling client side to try to defeat table locks
because MySQL can proceed with other clients as soon as the locks are
freed vs your application waiting for a complete result set to return
before proceeding with
