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

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