Before you read ahead, the problems that occurred to cause me headaches was partially my own mistake. However, I have not fully investigated other causes and will update the post once I get the chance to fully investigate the issue.
As a developer it is always easy to overlook minor things, some of them may not cause you much headaches, but some of them could eventually build up to give you nightmares because they are hard to spot.
Before I go ahead, please take a look at the screenshot below.
If you just saw a console with some SQL queries, let me point you to two big problems in the above screenshot.
The total rows in the table wp_postmeta (which holds meta info for posts) is more than 10 million, 10140712 to be precise.
The total number of rows in wp_postmeta without post_id is again more than 10 million, 10113548 to be precise.
To tell […]
Original post by Keith Dsouza
Technorati Tags: blog