-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: DotNetSaavy (Mr.BabuRaj)
Message 5 in Discussion
Sachin, This is what I've done, but the feedback I got was that that the table can
grow exponentially on a later date, where we will end up with redundant entries for
UserId in the Preferences table.For production server is it advisable to have this
kind of a design.Please advise. I have a junction table as below where I'm currently
storing the user preferences Table Name :- User Preferences UserId
PropertyId Priority Order ****** ******** *****
Ind1 1 500
Ind1 2 33
Ind1 3 92
Ind1 4 101 - - - -
- - - - - Ind1
600 24 don't you think user id column has redundant (repeating)
values of userid, in this case we will end up having 100*600 = 60K entries in the
table.If there is no other work around then I'm ready to stick to this approach.Do you
have any comments on NetPointer's approach above Thanks BabuRaj
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
