RE: [PEAR] benchmark tests on mdb + others

> -----Original Message----- > From: electroteque [mailto:daniel@electroteque.org] > Sent: Friday, January 24, 2003 10:27 PM > > hi guys did a quick benchmark check , with some really interesting results > > u can get it @ > http://www.dybnet.de/MDB/benchmark.zip > > > > http://electroteque.dyndns.org:1023/benchmark/benchmark/ > > if you go here u can check each one with filenames with bench at the start > of them > > here are the results in seconds i guess > > MDB - 13.13 > Metabase - 23.3 > ADODB - 13.33 > Pear DB - 20.88 > Mysql - 6.76 > PHPlib - 15.41 > Metabase Wrapper MDB - 15.26 > Pear DB Wrapper MDB - 19.02 > > i think MDB is a killer it looks pretty much the best at the moment , > although i dont understand what that does compared to the metabase and > pear > db wrapper ?? the Metabase and PEAR DB wrappers are just that: Wrappers that make MDB behave like its PEAR DB or Metabase. > still 6.76 for native functions rock , but i prefer not using native > functions :|, will MDB be the best way to go ? > > hope this helps wow, nice. Seems like I did a few other good things :-) Anyways don't overestimate this benchmark. 1) it is really simplistic in that it just fetches some data from a single table a lot of times 2) it uses MDB::fetchInto() which evades all the type conversion if statements that are found in the [fetch|query|get][One|Row|Col|All] methods. If you use these things will slow down. If you actually use the type conversions things will slow down even more. 3) it's a benchmark! It's a lying piece of *"$%&"! again I would like to point everyone to this thoughtful post by tomas that will shed some light on all of this: http://marc.theaimsgroup.com/?l=pear-dev&m=100793507904834&w=2 MDB incorporates most of the improvements that tomas proposed for PEAR DB in the post. Regards, Lukas