Nura111
asked on
empty rows
Is that a problem to have empty rows in the database (its in a content table)
can it cause slow queries?
can it cause slow queries?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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.
ASKER
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
ASKER
Thank you.