nan wich wrote:
Sam, I have a tendency to agree with you on the number of tables. I've kind of gotten used to it, but I sued to look at the database and say, "OMG, 125 tables?" That's one of the drawbacks to normalizing. The idea is that it allegedly ends up decreasing the count, I find that, in practice, it usually does not. In the olden days, before databases (now called NoSql), one could create a file with many different record layouts in it and still understand what one was working with. Just think of it as DBA job security.
Normalized data, yes, that is the way to go, one place to update one piece of information instead of hunt and find to change multiple pieces of the same information. Create a view to join the pieces together for the human reader. At least it isn't SAP where the business object code is stored in the database requiring an SAP provided editor to write ABAP (an SAP created language based on SQL). As was stated already, the number of tables in the DB isn't the measure of a performance issue. Someone claiming that it is just means they do not have an understanding of how to measure performance. -- Earnie -- http://progw.com -- http://www.for-my-kids.com