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)

  • 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

    (@janosd)

    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.