With many reviews its impossible to manage the internal panel

  • Resolved jmpads

    (@jmpads)


    3 months, 3 weeks ago

    Hello!

    I am using the plugin and I currently have more than 160k reviews and managing comments and deleting them is starting to get tedious. The page always gives an error due to time. What could it be? I see that the list in the admin panel only shows the last 8092. My problem is when deleting and approving/rejecting comments that it hangs when I mark several.

    Thank you very much in advance!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Gemini Labs

    (@geminilabs)

    I am using the plugin and I currently have more than 160k reviews and managing comments and deleting them is starting to get tedious.

    Does it show that you have 160k reviews on the All Reviews page? If not, where does the number come from?

    The page always gives an error due to time. What could it be?

    Site Reviews does not load all 160k reviews on the All Reviews page; it only loads the number of reviews that are being displayed (i.e. if you are displaying 20 reviews per page, it will only load those 20 reviews).

    If this is slow, a few things come to mind.

    1. Are your database tables using the old outdated MYISAM engine or the new INNODB engine? This makes a big difference in speed. You check this by going to the “Site Reviews > Tools” page and using the “Optimise Your Database Tables” tool.
    2. Check the Site Reviews > Tools > Console page and see if there are any warning or error entries which might point to a possible database issue.
    3. Sometimes other plugins modify the global database queries or use filter/action hooks inefficiently which may cause performance issues. I created the BlackBar plugin to help debug performance issues.
    Thread Starter jmpads

    (@jmpads)

    Thanks for the reply. There are 160k in total, the list I get in the panel. My problem is in the admin section, not in the public section of each page, as it is not able to manage everything when managing new reviews. My database uses innodb and I see this in the console.

    [2024-07-18 10:41:43] INFO [Modules\Validator\ValidatorAbstract:48] The Honeypot caught a bad submission.
    [2024-07-18 10:41:50] INFO [Modules\Validator\ValidatorAbstract:48] The Honeypot caught a bad submission.
    [2024-07-18 10:41:57] INFO [Modules\Validator\ValidatorAbstract:48] The Honeypot caught a bad submission.
    [2024-07-18 10:42:04] INFO [Modules\Validator\ValidatorAbstract:48] The Honeypot caught a bad submission.
    [2024-07-18 13:25:54] WARNING [Commands\CreateReview:106] The form referer ($_SERVER[REQUEST_URI]) was empty.
    [2024-07-19 11:31:47] WARNING [Commands\CreateReview:106] The form referer ($_SERVER[REQUEST_URI]) was empty.
    [2024-07-20 12:44:52] WARNING [Commands\CreateReview:106] The form referer ($_SERVER[REQUEST_URI]) was empty.
    Plugin Author Gemini Labs

    (@geminilabs)

    Hi @jmpads

    Can you please send an email to support[＠]site-reviews.com and include the Site Reviews > Tools > System Info and Console files?

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.