Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How much faster are MySQL transactions compared to single queries?

user-image
Question added by Faten Almajaly
Date Posted: 2015/09/02
Norman Rey Ratunil
by Norman Rey Ratunil , IT Technician , Computer Station Co.

Single Queries take turns while MySql Transactions specially those set of query that is relatively coded works simultaneously.

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

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.

Ahmed Hafez Amin
by Ahmed Hafez Amin , IT Senior Supervisor , Egyptian Tourism Federation

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 :/

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.