Re: PEAR DB abstraction layers
| From: | Lorenzo Alberton | Date: | Mon, 19 Apr 2004 19:45:26 +0000 |
| Subject: | Re: PEAR DB abstraction layers | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-28075@lists.php.net to get a copy of this message | ||
On Mon, 19 Apr 2004 18:25:57 +0200, Lorenzo Alberton wrote:
> On Mon, 19 Apr 2004 17:16:07 +0200, Martin Jansen wrote:
>> On Mon Apr 19, 2004 at 04:0039PM +0200, Lukas Smith wrote:
>>
>>> However MDB2 has the following:
>>> - is faster
>>
>> Do you have some concrete benchmark results to back this up? -
>> Martin Martin Jansen
>> http://martinjansen.com/
and here you are the ibase results... wow!
Who said that mysql was the fastest dbms on earth?? :-)
Best regards,
--
Lorenzo Alberton
http://pear.php.net/user/quipo
Apache/2.0.49 (Win32) PHP/5.0.0-RC1 Server at localhost Port 80 FireBird 1.5 superserver http://phplens.com/lens/adodb/ Benchmark ibase: Queried 200 times for 0.538825035095 seconds ibase: Queried 200 times for 0.563502073288 seconds ibase: Queried 200 times for 0.569548130035 seconds //with portability = MDB2_PORTABILITY_NONE and result_buffering = false PEAR MDB2: Queried 200 times for 1.03425812721 seconds PEAR MDB2: Queried 200 times for 0.990272045135 seconds PEAR MDB2: Queried 200 times for 1.0284409523 seconds //with default portability options (~DB_PORTABILITY_NONE) PEAR DB: Queried 200 times for 1.07333707809 seconds PEAR DB: Queried 200 times for 1.07814097404 seconds PEAR DB: Queried 200 times for 1.06434202194 seconds //with portability = MDB2_PORTABILITY_NONE PEAR MDB2: Queried 200 times for 1.43480491638 seconds PEAR MDB2: Queried 200 times for 1.38660216331 seconds PEAR MDB2: Queried 200 times for 1.45857310295 seconds //with portability = MDB2_PORTABILITY_ALL and result_buffering = false PEAR MDB2: Queried 200 times for 1.45222091675 seconds PEAR MDB2: Queried 200 times for 1.4973180294 seconds PEAR MDB2: Queried 200 times for 1.44575095177 seconds //with portability = DB_PORTABILITY_ALL PEAR DB: Queried 200 times for 1.55163002014 seconds PEAR DB: Queried 200 times for 1.51884794235 seconds PEAR DB: Queried 200 times for 1.49818992615 seconds ADODB: Queried 200 times for 1.54501008987 seconds ADODB: Queried 200 times for 1.53550291061 seconds ADODB: Queried 200 times for 1.57913517952 seconds PEAR MDB: Queried 200 times for 1.65952396393 seconds PEAR MDB: Queried 200 times for 1.76666903496 seconds PEAR MDB: Queried 200 times for 1.82110309601 seconds //with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 1.93726921082 seconds PEAR MDB2: Queried 200 times for 1.98050308228 seconds PEAR MDB2: Queried 200 times for 2.02188205719 seconds Metabase: Queried 200 times for 10.6406710148 seconds Metabase: Queried 200 times for 10.6714560986 seconds Metabase: Queried 200 times for 10.6872599125 seconds
Apache/2.0.49 (Win32) PHP/5.0.0-RC1 Server at localhost Port 80 FireBird 1.5 superserver http://phplens.com/lens/adodb/ Benchmark ibase: Queried 200 times for 0.538825035095 seconds ibase: Queried 200 times for 0.563502073288 seconds ibase: Queried 200 times for 0.569548130035 seconds //with portability = MDB2_PORTABILITY_NONE and result_buffering = false PEAR MDB2: Queried 200 times for 1.03425812721 seconds PEAR MDB2: Queried 200 times for 0.990272045135 seconds PEAR MDB2: Queried 200 times for 1.0284409523 seconds //with default portability options (~DB_PORTABILITY_NONE) PEAR DB: Queried 200 times for 1.07333707809 seconds PEAR DB: Queried 200 times for 1.07814097404 seconds PEAR DB: Queried 200 times for 1.06434202194 seconds //with portability = MDB2_PORTABILITY_NONE PEAR MDB2: Queried 200 times for 1.43480491638 seconds PEAR MDB2: Queried 200 times for 1.38660216331 seconds PEAR MDB2: Queried 200 times for 1.45857310295 seconds //with portability = MDB2_PORTABILITY_ALL and result_buffering = false PEAR MDB2: Queried 200 times for 1.45222091675 seconds PEAR MDB2: Queried 200 times for 1.4973180294 seconds PEAR MDB2: Queried 200 times for 1.44575095177 seconds //with portability = DB_PORTABILITY_ALL PEAR DB: Queried 200 times for 1.55163002014 seconds PEAR DB: Queried 200 times for 1.51884794235 seconds PEAR DB: Queried 200 times for 1.49818992615 seconds ADODB: Queried 200 times for 1.54501008987 seconds ADODB: Queried 200 times for 1.53550291061 seconds ADODB: Queried 200 times for 1.57913517952 seconds PEAR MDB: Queried 200 times for 1.65952396393 seconds PEAR MDB: Queried 200 times for 1.76666903496 seconds PEAR MDB: Queried 200 times for 1.82110309601 seconds //with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 1.93726921082 seconds PEAR MDB2: Queried 200 times for 1.98050308228 seconds PEAR MDB2: Queried 200 times for 2.02188205719 seconds Metabase: Queried 200 times for 10.6406710148 seconds Metabase: Queried 200 times for 10.6714560986 seconds Metabase: Queried 200 times for 10.6872599125 seconds