PHP Classes

I'm afraid this script has no utility, at all - the only thin...

Recommend this page to a friend!

      MySQL Multi Query  >  All threads  >  I'm afraid this script has no...  >  (Un) Subscribe thread alerts  
Subject:I'm afraid this script has no...
Summary:Package rating comment
Messages:1
Author:Junkie Narkosvin
Date:2012-05-14 13:40:00
 

Junkie Narkosvin rated this package as follows:

Utility: Bad
Consistency: Bad
Examples: Sufficient

  1. I'm afraid this script has no...   Reply   Report abuse  
Picture of Junkie Narkosvin Junkie Narkosvin - 2012-05-14 13:40:00
I'm afraid this script has no utility, at all - the only thing you can gain from a multi-query facility is fewer roundtrips, and this script doesn't give you that. It simply loops over a list of queries, one round-trip to the database per query.

If you need a multi-query facility, check out mysqli::multi_query() which is available in newer versions of MySQL - this lets you execute multiple queries in a single round-trip, eliminating some of the network (waiting) overhead.

I also rated this script "bad" for consistency - using 3-letter shorthands for property-names is extremely bad form. Imagine if all APIs used 3-letter shorthands. Yikes.