0
Let’s say I have a table with 4 columns and 4 records. Not all columns are filled in at the time of the form because it is not mandatory, so the database has some gaps in its grid! Example:
ID | Item1 | Item2 | Item3
---------------------------
1 | Dado | | Dado
---------------------------
2 | | | Dado
---------------------------
3 | Dado | Dado | Dado
---------------------------
4 | | Dado |
---------------------------
My doubt is:
This "blank" in the records may affect performance in some way at the time of database query?
Compared to what? I know, it will mean not having these "whites", but that means little. My tendency is to say "just measuring" to know, although you can even elaborate a little more, but the usefulness of the information will be small. That is, in this specific case it is too abstract to pin a concrete statement :P
– Maniero
Basically the performance is more affected by the volume of data that the query will result and consequently have to traffic between mysql to php, than the time that mysql will take doing the search of the data itself (obviously speaking of querys not very complex).
– Jader A. Wagner
Being only a simple query query, the loss and minimum that even to measure would be difficult. Even if it was a more complex one and a huge bank, the loss would be minimal. I have tables with almost 200 thousand records in Sql server that is minimum the loss in relation to the query of the entire table. imagine if it’s a specific record.
– Willian Coqueiro