Database Design: Table max column number
As I mentionned it in many of my previous posts, I'm currently working on a personal project. Since it's going to manage a lot of informations, tables of my database have a pretty big number of columns (like 30 columns)... I know what you're going to tell me : Normalize your database ! Of course I did and it's normalized, but these 30 fields really are native properties and core data of my entities.
Since the application will have a lot of users and a real need of scalability, I was wondering if 30 columns in a table is a problem or not... Does it have any consequences at the performance level ? If so, I guess I would have to normalize a bit more, but another problem appears here : over-normalization which is also a performance degradation cause... Do you guys have any advices about that ?