Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How much faster are MySQL transactions compared to single queries?

user-image
Question ajoutée par Faten Almajaly
Date de publication: 2015/09/02
Norman Rey Ratunil
par 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
par 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
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?