Register now or log in to join your professional community.
Single Queries take turns while MySql Transactions specially those set of query that is relatively coded works simultaneously.
with in my knowledge, a single query is a transaction. I think you may be want yo compare with stored procedures which are the blocks contains set of queries pre-compiled and stored at server side in order to reduce the query traffic between client server. Obviously they meant for the purpose and the advantage is to reduce the traffic and speedy execution or efficiency rather executing the queries individually. they have their own advantage and disadvantage as well. If a procedure without proper set of sql statements may put you into task like table scanning and never comes out from it, so purely depends upon the efficiency of your set of queries in a block/procedure. Thanks.
that's related to how much complex is the query !
that's because for Example
if the query takes10 ms overhead , the transaction will take1 ms
and if the complexity of the query increased and takes20 ms overhead , the transaction will take also1 ms.
so it's can't measure as fixed percentage because it changes depend on the complexity of the query.
that's what i think :/
