Skip to content Skip to main navigation Skip to footer

How to reduce size of wp_mlw_results table?

Welcome to QSM Support Forum. › Forums › QSM Pro Support › How to reduce size of wp_mlw_results table?

Tagged: 

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • March 21, 2020 at 9:04 am #2769
    mark.stevens@easivisa.com[email protected]
    Participant

    I have about 4800 quiz results in total which is resulting in a 77MB table size for wp_mlw_results.

    I have used Bulk Delete from within the Results page of the plugin and deleted all but about 40 of these results, but the plugin seems to be just marking the rows as deleted rather than actually deleting them from the table, so the table remains the same size.

    This is clogging up my site unnecessarily and causing me issues

    How do I get rid of those old results completely and reduce the size of the wp_mlw_results table?

    March 23, 2020 at 6:17 am #2786
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Mark,

    Welcome to Qsm Pro Support Forum. Hope you are having a great day.

    I have to contact the development team regarding this. I will be right back to you as soon as I hear back from them.

    Regards,
    Kriti

    April 13, 2020 at 5:28 am #3164
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Mark,

    Our developers have recorded this feature request and it will take 2-3 weeks to implement. Meanwhile, you can delete it directly from the database.

    Regards,
    Kriti

    April 26, 2020 at 6:34 pm #3446
    Kriti SharmaKriti Sharma
    Keymaster

    Hi,

    We have implemented the bulk delete functionality in the latest version of the plugin. Please see the following video: https://drive.google.com/file/d/1H7A1RMiJbvZCtazVveqpdW9hqKbfU64F/view

    Best regards,
    Kriti

    December 5, 2024 at 4:02 am #11915
    David VeloDavid Velo
    Participant

    To reduce the size of the wp_mlw_results table in WordPress, start by backing up your database. clipping path service provider Delete outdated or unnecessary quiz results directly through the plugin or database. Use optimization tools like WP-Optimize to clean up table overhead. Configure result retention settings within your quiz plugin to limit stored data and ensure regular maintenance to keep the table size manageable.

    December 11, 2024 at 3:04 am #11953
    Laurine FunkLaurine Funk
    Participant

    Great sharing, very impressive, thank you very much. fnf mods

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.