[development] Do not let postgresql hold back great patches

Bill Moran wmoran at potentialtech.com
Fri Nov 30 18:40:32 UTC 2007


In response to "Edward Z. Yang" <edwardzyang at thewritingpot.com>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> > Take, for example, that COUNT(*) is _really_ fast on MySQL + MyISAM,
> > but is slow on just about every other DB.  So, replace it with
> > $db->count(), which does an SQL COUNT(*) on MySQL + MyISAM, but uses
> > some other technique on other databases.  The programmer no longer
> > cares _how_ such a thing gets done, he only cares that he wants to
> > know how many rows are in a particular query
> 
> The primary problem with this approach (at least in my experience) is
> that the moment you need to create queries that are even somewhat
> complicated the abstraction layer proves to be insufficient. Ad hoc
> queries are often very useful for performance reasons, but you'll have
> to get a PostgreSQL guru to write an equivalent.
> 
> Then again, for most people writing SQL performance/complex joins/etc
> are not a primary concern...

Well, if such an abstraction solves 90% of the problems, the gurus will
have more time to deal with the remaining 10%.

Assuming it can be done well enough to actually solve 90%.

-- 
Bill Moran
http://www.potentialtech.com


More information about the development mailing list