http://phplens.com/lens/adodb/#1
The PEAR one takes almost twice the time of all other wrappers, with the exception of M'base.
I hate it when my prejudices are confirmed. Makes my life boring. ..
Moderator: General Moderators
In some of the benchmarks that I've done, PEAR DB performs better. I would say they are fairly equivalent, just optimized for different things. adodb has an optimized inner loop and the test above shows it off. If you look at the second benchmark on that link, you will see that PEAR beats adodb for a more realistic example, but only when you do not have an opcode cache. Do you have 5*200 82 record SQL queries per request in your app? Benchmarking is the devils game.patrikG wrote:BTW, I've just come across some benchmarks comparing different DB-wrappers:
http://phplens.com/lens/adodb/#1
The PEAR one takes almost twice the time of all other wrappers, with the exception of M'base.
Replacement - no. Alternatives? Yes, absolutely.patrikG wrote: I don't think a replacement for PEAR is necessary - if one remembers where it's coming from, I start to believe that it's actually making headway - and into a good direction.
So lets recap - we have a group (PEAR-dev) that says "this is the best, and this is the only way we will do DB access". Then you, as a programmer, look at that method for doing DB access, and see a BETTER version in adodb. So now you have a choice - you can use adodb, or you can use PEAR-db.patrikG wrote: All of us developers arguing about the benefits of our template classes, our great database wrapper or this, that and the other are missing one thing: a real code library. Unless that is there, PHP will always be somewhat of a step-child of "proper" programming languages like Java and C (in all it's variants).
Oh things are moving ahead all right, just not in PEAR generally.patrikG wrote: Let's face it: we (and by that I actually mean I) are a bit like the step-mom always moaning that this and the other is not right, while we are actually not seeing that things are really moving ahead.
No, you misunderstood me, Roja. I am not arguing for a monopoly, but for a coherent, well documented standard code-base which every PHP-developer can use. Whether there is one DB-wrapper or 10 doesn't matter to me as long as the one I am using works fine and does what I want (oh, PEAR has five different template classes, btw).Roja wrote:So lets recap - we have a group (PEAR-dev) that says "this is the best, and this is the only way we will do DB access". Then you, as a programmer, look at that method for doing DB access, and see a BETTER version in adodb. So now you have a choice - you can use adodb, or you can use PEAR-db.patrikG wrote: All of us developers arguing about the benefits of our template classes, our great database wrapper or this, that and the other are missing one thing: a real code library. Unless that is there, PHP will always be somewhat of a step-child of "proper" programming languages like Java and C (in all it's variants).
Code libraries thrive on competition. PEAR-dev has rejected that fundamental advantage.
Personally, I don’t see PEAR being a “us and them” scenario. PEAR is something I would like to see become the way it was supposed to be – so that PHP becomes simpler and people don’t need to constantly re-invent the wheel.Roja wrote:Competition is key, and PEAR doesnt get that. Never have, never will. Which is why they will lose.