Load with Pagination (MySQL)

  • Resolved herbetferreira

    (@herbetferreira)


    9 years, 9 months ago

    I have the plugin installed on my site which has over 4,900 registered users. It’s a big site. The problem is: Today the site has more than 1 million rows / actions of users in the database. In Control Panel, when I click to view the history of actions, the page does not load. Simply the page crash because of the time spent loading the information.

    I believe that the best solution would be to create a paging (20 results per page on the mysql query’s (LIMIT)) before to load all the history information.

    It is possible to do this?

    Thank you.

    https://www.ads-software.com/plugins/simple-history/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author P?r Thernstr?m

    (@eskapism)

    ah, I have not tried the plugin with that large amount of users. but of course it should work for that kind of site too. you are probably correct that it crashes somewhere. it does already use a LIMIT on the main query, but I think I could optimize the subqueries a bit.

    I will create that amount of users on my local test site and also create a large amount of actions, and see if I can break my local site and then unbreak it again ??

    sorry for the inconvenience and hang in there for a while and we should be able to solve this..

    Plugin Author P?r Thernstr?m

    (@eskapism)

    btw, for how long do you keep the entries in the database?

    Thread Starter herbetferreira

    (@herbetferreira)

    I need to keep the full-year data. Because I need to create reports with data from the whole year.
    The site that I work is an official site of judiciary of a state in Brazil. There are many news, pages, post types, etc.

    Plugin Author P?r Thernstr?m

    (@eskapism)

    hey again
    i’ve done some work to speed up the log on very large logs. I already did have some LIMIT’s in there for the pagination, but it did need some other work too

    in my testing it now works much faster, but it would be great to see if it also worked for you (before I release any changes to all users of the plugin). Would you be interested in testing a new beta-version of the plugin?

    if so, send me an email at [email protected] and I will provide a ZIP for you to test. thanks!

    Plugin Author P?r Thernstr?m

    (@eskapism)

    This should be fixed now with the last update (2.1.2). Thanks for the help!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Load with Pagination (MySQL)’ is closed to new replies.