Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Recommendation on a design issue
Message
De
22/02/2009 21:42:45
 
 
À
20/02/2009 03:35:58
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01382935
Message ID:
01383390
Vues:
38
>Some important information is missing:
>Do all members have one or more choices?
>What's the average number of choices per member?
>If you want to find which choices are selected for a particular member then the single table might be faster. But if you need to determine which members have a specific selection of choices then the current setup might be quicker since you're presumably selecting from a much smaller table.

They can have multiple choices. The average would be two. The decision was to keep it as is. So, I kept the design which is relational and we'll see how it goes.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform