ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

Norman Rey Ratunil
من قبل 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
من قبل 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
من قبل 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 :/

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟