Title: Does deleting old posts from database decrease server load?
Last modified: August 19, 2016

---

# Does deleting old posts from database decrease server load?

 *  [janosd](https://wordpress.org/support/users/janosd/)
 * (@janosd)
 * [17 years ago](https://wordpress.org/support/topic/does-deleting-old-posts-from-database-decrease-server-load/)
 * Maybe its a stupid question but lets say i have x thousand posts and delete everything
   except every tenth posts, will the mysql queries be faster or no since there 
   will be skips in the indexes and it cant estimate the position of the posts well
   in the database table.
 * OR maybe i dont understand mysql at all :-D. please help.
 * cheers

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [stvwlf](https://wordpress.org/support/users/stvwlf/)
 * (@stvwlf)
 * [17 years ago](https://wordpress.org/support/topic/does-deleting-old-posts-from-database-decrease-server-load/#post-1086880)
 * There would be no skips in the indexes because when you delete a post the entry
   is removed from the index altogether. There is a “Repair” and “Optimize” function
   in MySQL that you can access in PHPMyAdmin. If you do a lot of deleting its a
   good idea to occasionally optimize the tables.
 * You are not going to see any noticeable speed increase in query retrieval time
   going from 2,000 posts to 200 posts.
 *  Thread Starter [janosd](https://wordpress.org/support/users/janosd/)
 * (@janosd)
 * [17 years ago](https://wordpress.org/support/topic/does-deleting-old-posts-from-database-decrease-server-load/#post-1086913)
 * Aha! Thank you. I will use that Optimization.
 * The reason behind my logic was that, i usepost_id in my permalink structure for
   first, because i read its good for performance.
 * And well, i will have about 10-20 posts “real” posts a week and about 2-300 temporal
   posts (!), which will be deletied ina month. Thats why i think about these think
   cause i dont want to break down when the site get popular youknow.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Does deleting old posts from database decrease server load?’ is closed
to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [janosd](https://wordpress.org/support/users/janosd/)
 * Last activity: [17 years ago](https://wordpress.org/support/topic/does-deleting-old-posts-from-database-decrease-server-load/#post-1086913)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics