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
  • Wordpress 2.0 plugins One of the real hesitations I had in moving current sites to Wordpress 2.0 was the thought of "what plugins will break?" From what I saw the supported plugins list was short and so was the "broken" plugins list. Which said many were likely untested. So, after I installed a......
  • The Continuing Stooo-ry of the Sony DRM rootkit debacle.... Let's see there are a couple more notes to pass along on Sony DRM rootkit news. This story could go on for some time, it's already had legs for about a week or more and just when things started to wind down a bit, there's a bit more. First up,......
  • Phishing - so many flaws to exploit so little time In the last week there was a well documented writeup of a cross site scripting vulnerability which had allowed a phisher to pose as a paypal login with THE LEGIT PAYPAL SSL CERTIFICATE.... Brian Krebs at the Security Fix has some details on some of the new and interesting ways......
Blog Traffic Exchange Related Websites
  • 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......
  • The Definitive Onpage Wordpress SEO Tutorial photo credit: dcJohn If you have any kind of Wordpress-powered website - whether that's a static site or a regularly updated blog - then you may well have fallen prey to one of the most common Wordpress SEO myths around. And it's costing you a lot of traffic... If......
  • 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