Hi all i have question.
this bellow table design is first 1. I've companies and their templates.templates in file table i related columns like below.
ID - CompanyID - Description - FileID
ID - Description
ID - CompanyID - FileID - FileTemplateID
Now question , which design is better for perfomance and maintinance there is will be ver much data (1 million) will be very active table
asked Sep 29, 2011 at 01:10 PM in Default
There's no easy way to answer this without understanding what kinds of queries are being run against the data AND the relationships of the data. The thing is, in your first design, will you be duplicating lots of data in order to store the information? If so, that can be a performance issue. But from what you've supplied, it's very hard to give you a definitive answer.
In general, default on the side of normalizing the data and the relationships and ensuring that those relationships are enforced. That's how SQL Server is designed to work and that's where the enhancements and optimizations focus.
answered Sep 30, 2011 at 04:45 AM
Grant Fritchey ♦♦