On Mon, Jan 05, 2004 at 08:14:31PM -0700, Daniel Crookston wrote: > Ewww, sub-selects. Not a very efficient use of the DB, is it? I was under
I think you are right. Subselects are used sometimes when just a simple join is called for. The join would most definitely be faster. > the impression that it's just as fast (with MySQL at least) to just do the > sub-select yourself in the code instead of relying on the database to do it. I don't know if I agree exactly with the idea of "code it manually instead of relying on the database". I would argue that anything the database can do for you, for instance, enforcing key constraints and so forth, the better. The less you have to code, the less likely you will make mistakes. -- Phillip Hellewell <[EMAIL PROTECTED]>
pgp00000.pgp
Description: PGP signature
____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
