Tag Archives: wordpress database

  • -

WordPress Your Sitemap and Google | MindVisionMedia.net

Tags : 

WordPress Your Sitemap and Google | MindVisionMedia.net:

Hello to all from Allan at MindVisionMedia.net and I hope this post finds you well.

Few realize the importance of your sitemap when it comes to Google. The sitemap, for those who are not familiar, is a file that tells Google or some other company, what pages to “fetch” or scan on your website from time to time and it represents a tree or directory to the pages most important in your site to your visitors. This file has(usually XML) ahs more than one purpose, it assists in updating the search engines and helps people find you based on your content. This process involves repeated scans or “fetches” by Google which are set at an interval you can modify if needed.

sitemap3The other purpose of directing your visitors to the pages they want or your sites map, is performed by the same file but displays in a browsers window as the result of a link or button being pressed. One function performs behind the scenes with Google and the other performs on screen as a tool or guide to find your content.

There are many sitemap Plugins that zip out a sitemap for your site or Blog, but you’ll want to edit or take the time before-hand to set up some limits before creating the sitemap. The most common form is an XML file but some programs offer a choice of XML or HTML. I use an HTML version for my site visitors and an XML version for Google.

The power of the sitemap is in adding instructions that tell the search engine when and how to check for updates in your content, by date, frequency, by category, by specific page or post, etc. The point here is to make sure you are not including pages that don’t relate to your target market directly and maximize the intent of the sitemap to make these Google fetches targeted and effective.

sitemap2You don’t want Google indexing your contact page, image galleries, pages not complete yet or made public, or your privacy statements when there are other more pertinent pages or posts that directly relate to your target niche. Look at these scans by Google as wasted because Google scanned  unnecessary content for nothing, Nada, zilch, of zero benefit to you or I or more importantly, our site.  This includes any information (pages, posts, media file pages, etc) that don’t help your search ranking or your seekers find you for the information they need.

Another negative affect to having Google fetch a bunch of extra pages or every page in your site is the impact on your sites resources! That’s right, each fetch generates queries in your database. Your query limits could possibly be affected, compiling any other burdens on the database currently by having a bloated sitemap in combination with a high fetch rate. You may be faced with a slow loading or inaccessible site as a result and in some cases for large sites, you will have to adjust the fetch rate for Google’s Bots, to reduce the time between automatic fetches and minimize the burden on your resources.

A good sitemap will only have the pages or posts most relevant to the content, keyword, niche combination, thus maximizing Google’s efforts to index your relevant content which will in turn improve your relevancy in searches. It really is a science, a symbiotic thing when it all works together and for the big guy’s, who have marketing firms, web development companies or teams working on site refinement, SEO and Analytics, the end result is amazing, we see their presence everyday. But for the small guy or gal managing their web presence alone, it can be daunting and time consuming. Just when you think you’re done, there is something else you need to do to refine your site even more to compete.

Best Practice:

  • Always edit and maintain sitemap to give clear instructions to Google Bot
  • Target your niche in searches and only add relevant content in sitemap that you want indexed
  • Adjust Google fetch rate according to your update frequency and available resources.

So don’t neglect, or entrust your sitemap to some free plugin entirely, examine your site’s map and you will often notice references on there that are not needed. A little refinement goes a long way and has several benefits as you can see.

Allan Whitney

  • -

Best WordPress Plugin for Revision Removal

Tags : 

WordPress | Optimize Database after Deleting Revisions Plugin

Do you have a ton of revisions but don’t know what to do?

Optimize-Data3Not often do I write a review but this caught my eye. You might recall that I briefly mentioned a couple of plugins in a recent post about WordPress Revisions eating up resources in your database. Obviously, the revisions feature is a necessity in a CMS like WordPress or any other. I love the feature and have had to use it on more than one occasion.

There are sites that use it quite frequently and deliberately. But having a setting that allows you to decide for yourself, based on your individual needs, i.e. you are a writer or run an article site or magazine site, etc, or you rarely write anything, would be a great addition the arsenal of WP.

Having used several database management plugins, I have discovered my favorite and just have to let people know more about it. Once you set this thing up, one click gets rid of all the extra revisions that fall outside your parameters in an instant. It even gets rid of transients, spammed items and unused tags as well as keeping a log file.


For example, I had over 115 revisions on just one page in my site because I was testing out some new plugins and layouts, ah, thats kinda overkill on the revisions I think guys. Anyway, I digress, Back to the story, somewhere in a town in the Netherlands lives and works a man, a web developer, artist and partner in a web development company in Eindhoven called CAGE Web Design, Rolf van Gelder is his name. Rolf created a plugin called “Optimize Database after Deleting Revisions” (current version 2.7.7).

I mean the name of this plugin just screams simplicity and it actually does what it says which deserves credit these days. The setup and settings are easy and give you good refinement on what you want to keep in terms of revisions. I only keep (2) revisions no matter what I am editing!

It keeps the clutter down and a load off my database which is always good with a large site like mine. And as you will see below, it saved a ton of space in my database for MVM. Rolf thought of everything, it even lets you choose the tables and rows in the database you want to exclude or include, he did a really good job, KUDOS Rolf from the States!

Optimize-Data1You saved me a ton of resources on my overloaded database and increased my caching and load time, both front and back while editing. If you haven’t heard of this one, you might want to check it out. Its available through your WordPress Plugin Dashboard,  just search for the name.

The “total savings since first run” in the picture below indicates how much total space this plugin saved out of my database allocated to “revisions”! Twelve and a half MB is a lot for a database so just consider how many revisions you have since you upgraded WordPress, it could be as much as me or even more!

Here is a link to the developers site,
Optimize Database after Deleting Revisions

Allan Whitney

  • -

WordPress 3.8.1 Revisions feature causes Database problems!

Tags : 

WordPress 3.8.1 Revisions feature causes Database issues!

Hello from Allan at MindVisionMedia.net, I hope this post finds you well.

I love the new WordPress versions, they are full of nice changes and features but I recently started having serious issues with my WordPress website. Load time for everything was beyond forever and most of the time whatever I was trying to accomplish timed out. Logging in was a nightmare, trying to edit a page or post was a nightmare, and dealing with my hosting company over the issues was a nightmare.

In the end here’s what I learned:

WordPress-3-8-1-upgrade-550x349-435x349The new versions (3.8.1) of WordPress have built-in a revisions feature that is great in theory, but in reality, we don’t need a copy being saved every minute and we definitely don’t need our hosting company trying to charge us for more database space because we have reached our quota which is what I had to deal with in my case. I was exceeding my database quota several times a day and as a result, I could not log in or get any work done, extremely frustrating to say the least.

After going around and around with my hosting company who apparently didn’t have a clue when it came to my database, I started doing my own research and discovered that the “revisions” feature is causing problems everywhere. Especially for larger sites or sites with lots of posts or pages such as mine. I then researched some database plugins and settled on 2, “Optimize Database after Deleting Revisions” and also “Revision Removal”, both plugins helped me accomplish my goal of deleting all revisions, setting the max revisions to (2) and optimizing the database after reducing its size to less than half its previous size! If you use WordPress, then you are familiar with these words: “Thank God for plugins”

While researching I found numerous people suffering the same issues with their database and there are tons of Google topics on the subject of reducing the database size because of the “revisions” feature in the latest version of WordPress. I am hopeful that WordPress developers will reduce the capability of the revisions feature and limit the revisions to 3-5 max. It appears that no thought was given to the impact of saving so many revisions on the database and I would expect them to correct this very soon.

We all like having a backup copy of our work and the security of knowing that if something happened like a power failure, we would have a revision to fall back on, but in one case I had 115 revisions to just one page alone! Multiply that times 30-40 pages on a site or blog and you end up with hundreds of revisions eating up your database. With so many great features added to the new version, I can’t figure out why they overlooked this flaw. After a week of headaches and frustration, hours on the phone and support chat with my hosting company and hours of my own trying to research and solve my slow-loading and hanging problem, I am finally back to normal thanks to those 2 plugins.

So for anybody else experiencing slow page load, slow log in, slow page or post editing, check your revisions, if the numbers are high, it could be that the number of revisions you have is slowing down your database and site and could cause you to be dead in the water as far as getting any work done. So far I love everything about the new WordPress except for the “revisions” feature, it is too much (over-kill) so please WordPress Developers, add options or limit the number of revisions that are saved as well as the time between revisions being saved, and add some built-in controls to delete revisions or set how many revisions you want to keep.

We all need to give our feedback to WordPress so they can resolve this issue ASAP so please chime in on this subject and let them know. Thanks!

Allan Whitney

February 2018
« Jan    

2015 | Need a Website? Need WordPress Theme Modification? Get Started Now!