WordPress plugin stattraq speedup

I’ve made mention I think that I use the stattraq plugin for wordpress as one of the ways to see where traffic is coming from on the site, etc. etc. etc. I think I mentioned it as one of my stat tracking tools about the time Google Analytics limped out of the gate… Anyway.. one of the things that had bugged me about it for some time was that it was SOOOOO slow to pull up any information (maybe a minute to pull in the page?) I had noticed a performance tip from the author…

Now the stattraq page pulls up in 3 seconds or so. Basically it’s pretty easy to do. You do have to load up phpmyadmin for it though….

“If you’ve got access to PhpMyAdmin for MySQL you can add indexes into the table. For some reason I never did this and it really slows the StatTraq report queries down. If you add them to the ‘access_time’ and ‘article_id’ columns StatTraq will respond much more quickly. This change will be in future versions of StatTraq.”

So, phpmyadmin…. select database, select wp_stattraq (or whateveryourprefixis_stattraq ) You will see a listing of all of the fields ” Field Type Attributes Null Default Extra Action” is likely what you’ll see across the top. Underneath the Extra Action column there are a number of small icons.

First make sure you’re in the right column for either access_time, or article_id, Look for an icon that has a lightning bolt running across it (underneath extra action), hover your mouse and it should say “index”.

Click on that and all should work. It may take as long as 30 seconds or so, or as little as 1 second (depends on the database size, a bigger database means longer wait before the page refreshes.) Once the index is built for BOTH access_time and article_id fields you should see much quicker response from stattraq. (My last check took 1.239 seconds to pull… NICE)

Related Posts

Blog Traffic Exchange Related Posts
  • Virtual Server on Apache to listen on an alternate port In the last few days, I had to set up something a bit unusual with apache. Basically the goal was to have apache listen for connections on two different ports (the standard port 80 and an alternate port 85). The problem was that I wanted different content at each port.......
  • IE 7 INCOMPATIBLE with WORDPRESS blogs using the stattraq plugin I've FINALLY tracked down what was causing the issue with displaying my page in Internet Explorer 7 (RC1). It turns out that the stattraq plugin in wordpress (stattraq site) is part of the problem. Now, I don't understand exactly WHY... because I do have stattraq on each of the sites,......
  • The spammers win a round There is a company (well, unfortunately, WAS a company) called Blue Security. They had an innovative approach to stopping spam. A small download essentially sent opt-out return emails that were junk back to the REAL spam sender (clever concept huh? bouncing to the person that REALLY sent the message... Of......
Blog Traffic Exchange Related Websites
  • SEO Principles for WordPress Blogs WordPress is a relatively SEO friendly blogging tool to begin with. It offers a linking structure that makes it relatively easy for spiders to crawl your pages, and the code contains very little validation errors if any at all. However, there are a few additional steps that you can follow......
  • Basics of Video Sitemaps - Video Released By Google For Beginners Sitemap is a file which tells search engines, what pages to index ? Recently, Google added support for video (more content type like images too) sitemaps which tells the location of videos (along with few more information). This actually helps webmasters, bloggers to add their own videos to Google's index......
  • Related Websites Welcome to the power of relevant chaos. The Related Websites plugin is the latest to come from the labs of the Blog Traffic Exchange. The Related plugin has been built by a blogger for the benefit of fellow bloggers everywhere. There is no advertising present on member blogs - only......
www.pdf24.org    Send article as PDF   

Similar Posts

See what happened this day in history from either BBC Wikipedia
Amazon Logo

Comments are closed.

Switch to our mobile site