This code takes about 0.065 seconds with mysql_query:
$dateAdded = date('Y-m-d H:i:s');
$lastChanged = $dateAdded;
$startTime = microtime(true);
$result = mysql_query('BEGIN');
for ($i = 0; $i < 100; $i++) {
$email = 'test_ ' . $i . '@gmail.com';
$quer
Even without quoting ration remains the same: with Zend_Db_Adapter inerting
subscriber in the loop (for example) 1 is 3.5 times slower.
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/why-Zend-Db-Adapter-happened-to-be-much-slower-than-mysql-query-tp3241
Since you're using transactions I don't see why there would be such a big
difference between Zend_Db and mysql_query(). Have you tried running this
several times and averaging the results?
If these results are consistent, you might want to try modifying your timer
so you can see how long it takes
I don't beleive that using Zend_Db is several times slower, maybe I'm doing
something wrong with it.
These results seems very suprising to me.
--
View this message in context:
http://zend-framework-community.634137.n4.nabble.com/why-Zend-Db-Adapter-happened-to-be-much-slower-than-mysql-query-tp3