Dec.16

How to optimize wordpress website

We have many option for optimizing wordpress website. From these some of them are described below:

 

Catching :

We can make site fast and re bust by using catching implementation on website.

 

Query Optimization:

Reducing unrequired column on Post table:

WordPress framework has used simple table structure. All the post and page content are inserted in single table. The content of any page and post are putting next column for revised content of individual page. If we have maxmium of this unrequired column on table it makes effect on processing time of quering process. We need to remove this unrequired column on that table .

See below the query for getting all content in individual table and unrequired column of table in the post table.

To see how much the column in that table:

select count(*) from wp_posts

where wp_post is table name.

 

Find unrequired revision content on table.

select count(*) from wp_posts where post_type=’revision’

 

 

Query to remove the unrequired revision column on the table.

delete from wp_posts where post_type=’revision’

 

 

 

 

 

 

 

 

Share this Story:
  • facebook
  • twitter
  • gplus

Leave a comment

Facebook Comment