Re: MDB slower than DB ?

le 13/12/02 13:41, Lukas Smith à smith@dybnet.de a écrit : > 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. The code I use makes a lot of $db->getOne($query) and the queries contains mostly count(*). This is for a statistics page. Actually, there's only one fetchRow for just one row returned. This was made with the mysql wrapper. Could this be slower because of getOne() ? Bertrand Mansion Mamasam