[snip] That's up to you of course. Personally, I think some things are better handled by the database and some are better handled by the programming language. Things like conditional logic tend to be best handled by the programming language in my view. Your mileage may vary ;-) [/snip]
AT the risk of starting a religious war, I disagree to a degree. If the conditional logic on the programming language side does not cause or invoke more calls to the database that would be OK, but generally the less you have to go to the DB the better. If the conditional logic in the query causes less information to be returned you gain efficiency on both sides of the coin generally. Note that I said "generally". Sometimes it is much more efficient to retunr larger datasets to the application and work the magic from there. If your databases are formed well, indexed for the job at hand, and the queries are written smertly you are better off putting more of the conditional logic in the query. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
