On Sat, 29 May 2010 13:45:37 -0700 (PDT) Bryan <bryanjugglercryptograp...@yahoo.com> wrote: > You're not doing the query optimizer any favors. It can normalize the > query to the same thing either way, so we might as well write it to be > readable by people. I can read D'Arcy's at a glance.
Assuming that you are running a decent *cough* PostgreSQL *cough* database engine. Readable is good. If you have a problem with your queries chances are that reorganizing your data or adding proper indexes will do more for you than contorted SQL will. -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. -- http://mail.python.org/mailman/listinfo/python-list
