empty rows

Nura111
Nura111 used Ask the Experts™
on
Is that a problem to have empty rows in the database (its in a content table)
can it cause slow queries?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2009
Commented:
Empty rows dont affect your queries much differently than full rows.

The only thing is empty rows can fit more in a data block than a populated row.

Author

Commented:
empty rows can fit more in a data block than a populated row  - what is it mean?
Thank you.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
To add: I guess it all depends on how you define 'empty' rows.  If they are actual nulls, some databases don't index those so if you query based on an index, then no.

If empty rows are part of the actual select and you must do a full table scan then it might.

1 Billion 'empty' rows.  One populated.  You go after the one, you might have to wait.

It all depends on the database and how it handles things.

Commented:
What are the use of empty rows? More empty rows more issues and it might affect the queries. You could clean them up if you do not need them.

Author

Commented:
Its a wp_post table (wp database if you are familiar with it) if not just a table that save information on the content and from some reason there is a few rows with empty post_content

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial