"Archiving" Old Posts

Hi

My blog, http://www.systemlays.co.uk, has been around for a while and is now approaching 4,000 posts which is great.

However, i am wondering if this number will start to cause a drain on the overall site. I have recently encountered some problems with a couple of plugin's due to the number of posts.

So i was wondering if there was a way to 'archive' the oldests posts are reduce the weight they may have on the blog.

I am not sure if it is even an issue but i was thinking and so thought i would ask..

Thanks
Jon

  • Gabe
    • The Bug Hunter

    Hey Jon.

    Do you have caching enabled? If you enable caching you can minimize database queries so the page isn't reproduced every time someone views it. Also, plugins like related posts, broken link checkers, image compression, inefficient sitemap generators, improperly coded post view counters, some "seo boosters" and others use an inordinate amount of resources and are considered CPU/MySQL thrashers.

    If you don't have caching enabled, you can look at WP Super Cache, W3 Total Cache and others.

    You can also ensure your database is relatively clean and optimized. Here is a WordPress database optimization plugin: http://wordpress.org/extend/plugins/wp-optimize/

    Here's a whole article on WordPress optimization: https://codex.wordpress.org/WordPress_Optimization

    Specific to database optimization: http://www.problogger.net/archives/2011/08/24/how-to-optimize-your-wordpress-database-for-better-performance/

    Your website is sizable, but there are much larger sites out there that run fine. If the above doesn't help enough, you may need to consider a better hosting solution, especially if you're on shared hosting now.

    So, to answer your original question, you can't really 'archive' posts the way you can with files on a computer. Archives in WordPress are simply listings of older posts by date, author, category, etc. but aren't archived in terms of storing. Some combination of caching and optimization is probably what you're looking for. In fact, caching is like archiving in a way because depending on the settings, they shouldn't need to pull from the database again until they expire or something is updated.

    If you really want, I guess you could clean out your database by exporting those posts, but users won't be able to find them anymore and it's unnecessary.

    Hope this helps.

  • Tom Eagles
    • Syntax Hero

    Hiya, just going through some of the older threads here.

    As it's been a little while since we last heard from you I thought I'd check in to see how you're going?

    If you're still looking for some further assistance with this thread then please feel free to reopen the thread or of course for any new and related issues you are most welcome to open a new thread.

    Cheers!
    Tom

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.