Re: Re: Comparing ADODB with PEAR DB, Metabase and Native MySQL

Hi Jean-Michel, The source code and database schema is available from http://phplens.com/lens/adodb/ This was a test of database abstraction libraries, not db's so I choose the most common PHP database. PostgreSQL might be superior technically, but i wanted the benchmark to be widely tested. And no cached queries were used. Bye, John PS: the latest results with some additional benchmarks are now available MySQL 1.12 1.12 1.17 1.15 1.14 ADODB 1.43 1.47 1.47 1.44 1.45 PhpLib 1.53 1.62 1.64 1.64 1.57 PEAR 2.91 2.90 2.85 2.83 2.84 (fetchInto) PEAR 3.14 3.13 3.22 3.12 3.16 (fetchRow) M'base 4.51 4.55 4.46 4.54 4.52 (numeric columns) M'base 4.99 4.72 4.71 4.71 4.72 (named columns) Average Overhead MySQL 1.14 - ADODB 1.45 27% PHPLib 1.60 40% PEAR 2.87 152% (fetchInto) PEAR 3.15 176% (fetchRow) M'base 4.52 296% (numeric cols) M'base 4.77 318% (named cols) --------------------------------------------- Jean-Michel Poure <jm.poure@freesurf.fr> wrote in message news:4.2.0.58.20011026165610.00d21100@pop.freesurf.fr... Hello, What is the methodology of this test? What is your database schema, what are the SQL queries? ADODB has cached queries. Did you turn it off? Regards, Jean-Michel POURE At 17:25 26/10/01 +0300, you wrote: >úÄÒÁ×ÓÔ×ÕÊ, John Lim! > > MySQL 1.12 1.12 1.17 1.15 1.14 > > ADODB 1.43 1.47 1.47 1.44 1.45 > > PEAR 3.14 3.13 3.22 3.12 3.16 > > M'base 4.99 4.72 4.71 4.71 4.72 > >Of course native function will work faster, it's normal..:) > >As to ADODB and PEAR, IMHO, PEAR better when ADO, because >it have more flexible Error Handling.. > >M'base I don't use.. > >P.S. As to PHPLib DB, i does not like that class, >because if I try to write something like : > $db->query($sql); > while($db->next_record()) > { > ... > ..and I wnat to use values from recordset, > in another query, like.. > $db->query("... id=".$db->f('key')); > > It does not work, and should not..:) > } > > I need to create new object. $db2 = new DB_..() > And this obj create new connection to DB, > but I don't want this..:( > > So, it my opinion.. > > I like PEAR. > >-- >óÔÁÔØ ÏÂßÅËÔÏÍ, ÞÔÏÂÙ ÓÄÅÌÁÔØÓÑ ÐÁÓÓÉ×ÎÙÍ, > ÜÔÏ ÓÏ×ÓÅÍ ÎÅ ÔÏ, ÞÔÏ ÓÔÁÔØ ÐÁÓÓÉ×ÎÙÍ ÏÂßÅËÔÏÍ. > (Simone De Beawoir) >Best regards, > KVN (<http://php4you.kiev.ua/~kvn/>) > PHP4You (<http://php4you.kiev.ua/>) > mailto:kvn@phbme.ntu-kpi.kiev.ua > > >-- >PEAR Development Mailing List (http://pear.php.net/) >To unsubscribe, e-mail: pear-dev-unsubscribe@lists.php.net >For additional commands, e-mail: pear-dev-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net