On Mon, Jan 4, 2010 at 7:22 PM, Steven S. Critchfield <[email protected]> wrote: > Now that depends. I would agree for first rev of a project. But when > you start to see bottlenecks, you can custom write the query for that > section.
In a high load environment it is preferable to break the table into more tables with less fields so you simply don't have to write the custom query. That's the idea behind vertical databases and database partitioning in general. On the topic of bottlenecks, standards features having any potential for causing bottlenecks are mostly optional under MySQL. If you're a standards nazi and use MySQL, you'll be happy to know the --ansi option is documented here: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html -- Greg Donald http://destiney.com/
-- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en
