[Plugin: WP SlimStat] Loading Slowly – DB too big?

  • Resolved Ben Lobaugh (blobaugh)

    (@blobaugh)


    12 years, 1 month ago

    SlimStat has been starting to load slowly over the past couple weeks. Is there any known cause for this? I am wondering if there is some number crunching with all the data that could be slowing it down? I keep all of my stats for historical reasons and the DB is hovering around 35 megabytes right now. There are about a quarter million hits in it. Could that be the issue? I really do not want to give up my stats if there is any other way around it.

    http://wordpress.org/extend/plugins/wp-slimstat/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    Well, 250k is not such a big number, especially if your MySQL is optimized/dimensioned for your box. In my production environment I have about 500k rows in my slim_stat table, and the data rendering screens are pretty smooth.

    You may want to export your old data to a separate db and then run the ‘view’ queries there…

    Camu

    Thread Starter Ben Lobaugh (blobaugh)

    (@blobaugh)

    12 years, 1 month ago

    Ok, I was hoping it was not due to number of rows. That would indicate that SlimStat was doing some funky number crunching in a very inefficient way. My MySQL server is on a cluster dedicated and optimized just for MySQL. Maybe this issue is somehow tied into the corrupt table issue that keeps happening. When (more like if!) I have time I will do some more digging.

    Plugin Author Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    I admit I’m not a MySQL guru, so there could be room for improvement in my queries. Suggestions and ideas are more than welcome 🙂

    Camu

    MaxMcCann

    (@maxmccann)

    12 years, 1 month ago

    Hi Camu
    I have been using statpress on a few sites, and want to switch over to your plugin. After I delete the statpress plugin there is still a huge amount of data in the database. In PHPmyAdmin, would I simply “empty” that database record and then choose “drop” to remove all the data and records? Will this corrupt the database?
    Thanks for your help.
    Max

    Plugin Author Jason Crouse

    (@coolmann)

    12 years, 1 month ago

    Hi Max, you may want to ask this question to those who developed Statpress, I can’t speak for them on a such delicate issue 🙂

    Camu

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[Plugin: WP SlimStat] Loading Slowly – DB too big?’ is closed to new replies.