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.......
  • One alternative to Google Book (formerly Google Print) Search Engine watch has reported on a less controversial alternative to the Google Book Search (formerly Google Print). Less controversial, of course from the standpoint of Book publishers and those with concerns about Google's potential for their size and leverage. Ebrary, is the alternative. What frustrated me is what I......
  • 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,......
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......
  • 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......
www.pdf24.org    Send article as PDF   

Similar Posts


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

Comments are closed.


Switch to our mobile site