<div>
Do you know the objective of this table in your model? I mean, from a transactional perspective, a table with too many columns is not a good thing, but for example, if you use this table for reporting purposes or outbound interfaces purposes, it is not bad, because queries against your database will be simplified.<br />
So, the tip here is: understand your model, then take a decision.
</div>


Do you know the objective of this table in your model? I mean, from a transactional perspective, a table with too many columns is not a good thing, but for example, if you use this table for reporting purposes or outbound interfaces purposes, it is not bad, because queries against your database will be simplified.
So, the tip here is: understand your model, then take a decision.

<div>
I Agree with wpcortes. A table with lots of columns, only comes in handy as a calculated table (ie a View). For instance a table you fill up once a day and drop and recreate the following day.<br />
<br />
Greetings.
</div>


I Agree with wpcortes. A table with lots of columns, only comes in handy as a calculated table (ie a View). For instance a table you fill up once a day and drop and recreate the following day.

Greetings.

<div>
<div class="content wysiwyg-content">
Working on normalization of our existing database - we have too many columns in a table which are empty?<br />
<br />
a) Does this situation harm performance<br />
b)Or just take space<br />
c) What would be the fix? Is it to move such columns to other secondary tables and have 1:1 relation.
</div>
</div>


Working on normalization of our existing database - we have too many columns in a table which are empty?

a) Does this situation harm performance
b)Or just take space
c) What would be the fix? Is it to move such columns to other secondary tables and have 1:1 relation.

Working on normalization of our existing database - we have too many columns in a table which are empty

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.