A while ago, I had attempted to normalize a huge list I had to remove redundancy. This main list was hence joined with another 2 more lists as a result.
Right after, users were complaining about slow performance when querying the list through a webpart. Do note that the main list had a huge number of records. If I remember correctly close to list item threshold.
I hence reverted back to the non-normalized way, i.e. a lot of redundancy for those non-mandatory / non-relevant fields.
I have an upcoming project and am currently at the phase of designing lists and this made me wonder if I should attempt to normalize or not.
- Will normalization of lists affect performance positively or negatively? Why?
- Or is it more to how my querying is done that had affected my performance instead of structure of lists?
Appreciate your views in advanced. Thanks.