Hi All,

I have one question around Name Value pairs and Table Data.

In my project I have the requirement of configurable UI elements. Like DNN have the Configurable Panels.

What DNN uses is the Name Value pairs for the TabModule Settings for which we have specied our own properties. So whenever we change or add properties it saves it in TabModuleSettings and Name Value pair approach. In my case I want to use that as well and want to extend it little further with my own table in same structure for my Fields configurations. My fields will be displayed in Panel which is a part of module. But I want to go with DNN way. The only problem is that my every field will have 15 Configurable properties. And module (panel) is going to render the 50 fields which are all configurable and user will configure those from Settings.ascx (DNN way). But for every field it will add 15 entries to my name Value pair table. So for 50 fields it will add 750 rows. and let say if I have 3-4 such panels in my one page, so it will fetch 750 X 4 = 3000 records to display 200 fields. And then on UI layer I will manipulate and render one by one fields.

Will it worth to use this approach for storing configurations? Or can I go with the traditional approach of normalization of tables?

Please suggest some good solutions and also comment on performance if we consider any of the approach.

Thanks & Regards,
Deepak Khopade
deepak.khopade@lntinfotech.com (http://www.LNTInfotech.com )

Thanks for your kind reply :)