WordPress.org

Ready to get started?Download WordPress

Forums

WP Slimstat
[resolved] [Plugin: WP SlimStat] Loading Slowly - DB too big? (6 posts)

  1. 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/

  2. camu
    Member
    Plugin Author

    Posted 2 years 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

  3. 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.

  4. camu
    Member
    Plugin Author

    Posted 2 years 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

  5. MaxMcCann
    Member
    Posted 2 years 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

  6. camu
    Member
    Plugin Author

    Posted 2 years 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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic