Re: PEAR DB abstraction layers
| From: | Lukas Smith | Date: | Mon, 19 Apr 2004 16:26:38 +0000 |
| Subject: | Re: PEAR DB abstraction layers | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-28058@lists.php.net to get a copy of this message | ||
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 fasterDo you have some concrete benchmark results to back this up?
Until now, I've always trusted Lukas' statements about MDB[x] performances, but having the link of John Lim's benchmark suite at hand was too tempting... [:grin:] I have no web-server stress tool installed, so I just run each test three times. I know it is quite a ridiculous test, but it could nevertheless show a general performance index of each dbal
//with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 2.74024987221 seconds PEAR MDB2: Queried 200 times for 2.73800611496 seconds PEAR MDB2: Queried 200 times for 2.71783494949 secondsif you also set the "result_buffering" option to false it should speed things up as well. it will definately help to strain your servers memory less. regards, Lukas Smith smith@backendmedia.com _______________________________ BackendMedia www.backendmedia.com berlin@backendmedia.com Linn Zwoch Smith GbR Pariser Str. 44 D-10707 Berlin Tel +49 30 83 22 50 00 Fax +49 30 83 22 50 07