RE: [PEAR-DEV] MDB slower than DB ?

Hi, I ran the quite simple benchmark by John Lim (http://phplens.com/lens/adodb/) and MDB came out faster there. But this was using only MDB::query and MDB::fetchInto() which does not have any of the overhead of the optional MDB datatype support. The benchmark results can be seen here: http://freshmeat.net/screenshots/30313/ This can be mainly attributed to some of the issues in DB that were talked about in this post by Tomas Cox: http://marc.theaimsgroup.com/?l=pear-dev&m=100793507904834&w=2 Obviously if you use any of the methods (like all fetch* methods, that are the basis for the get* and query* methods) that do include handling of optional datatypes or even use the optional datatype support the performance will degrade. I would be interested in your specific benchmark or any observations you might have. Regards, Lukas Smith smith@dybnet.de _______________________________ DybNet Internet Solutions GbR Reuchlinstr. 10-11 Gebäude 4 1.OG Raum 6 (4.1.6) 10553 Berlin Germany Tel. : +49 30 83 22 50 00 Fax : +49 30 83 22 50 07 www.dybnet.de info@dybnet.de > -----Original Message----- > From: Bertrand Mansion [mailto:bmansion@mamasam.com] > Sent: Friday, December 13, 2002 1:21 PM > To: pear-dev@lists.php.net > Subject: [PEAR-DEV] MDB slower than DB ? > > Hi, > > I found out that MDB is slower than DB on a test I have made. > (don't ask me which test, it's a very difficult one...) > Wasn't it supposed to be faster ? > > Are there any other benchmarks showing speed of both packages ? > > Thanks, > > Bertrand Mansion > Mamasam > > > -- > PEAR Development Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php