Well it stands to reason that if you abstract something there is usually a performance penalty and I have seen other benchmarks showing the point but I could only find http://phplens.com/lens/adodb/ on google which although dated does show there is a performance hit. But I do take your point that there are plenty of other issues to look at at the same time.
Robin. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jochen Daum Sent: 21 May 2009 10:10 To: [email protected] Subject: [phpug] Re: query abstraction Hi, On Thu, May 21, 2009 at 9:15 AM, Robin <[email protected]> wrote: > I have been looking at different database abstraction layers such as propel > or pearDB and they seem soooo overly abstracted resulting in average > performance at best that I decided to write the simplest query abstraction I > could and I would like to get your opinions on why I would use propel or > pearDB instead of http://pastie.org/484625. > > Its really pointless to worry about the performance of the abstraction layer when: - unoptimised Mysql queries have 100 times the slow down effect - lack of query caching has huge effect - lack of page/snippet caching has huge effect Do you have any factual sources to claim "average" performance of a db abstraction layer? HTH, Jochen --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
