Website is getting slower – WCFM database table cleanup

WooCommerce Multivendor Marketplace – Home Forums WCfM – Feature Request Website is getting slower – WCFM database table cleanup

This topic contains 4 replies, has 2 voices, and was last updated by Avatar CommunityCorals 1 week, 5 days ago.

  • Author
    Posts
  • #70967
    Avatar
    CommunityCorals
    Participant

    Hello,

    I recognize that from week to week the response times are getting longer. I assume the issue is with size of the database. Is there a way to cleanup notifications in mass? I have 5000 notification e.g. that I don´t need. I assume vendors also have a lot of obsolete notifications. Erase all would be good.

    Any other idea of data that could be cleansed for keeping WCFM small and clean?

    Thanks
    Dominique

  • #71129
    WCfM Forum
    WCfM Forum
    Keymaster

    Hi,

    We will add that option very soon – schedule cleanup “Notification”, “Inquiry” tables.

    Thank You

  • #71141
    Avatar
    CommunityCorals
    Participant

    Very good ! Thank you guys you are amazing!!

  • #71145
    Avatar
    CommunityCorals
    Participant

    I also just used the media cleaner plugin to erase 19.000 unused images. Unfortunately the plugin also declared the store banners and logos as unused images. I have a copy of the system where those images are still available.

    Do you have any idea how to filter for those images and extract those?

    I know that is not really your concern but any idea would be very welcome :-/

    P.S. Strange is that the images are still visible on store listing but not in store page.

  • #71154
    Avatar
    CommunityCorals
    Participant

    We are just reviewing the database. Even if I have module analysis deactivated there are loads of data saved in wcfm_detailed_analysis.

    Also there are lots of empty and duplicate entries in postmeta for WCFM related data. It takes 2 seconds for every page just to run through postmeta as it is quite massive. Any idea how to make sure that datastructure can be kept as slim as possible or even more urgent how it can be cleansed to improve loadtimes? Website is getting slower from month to month. Check screenshot.

    Your help is much appreciated.

    Attachments:
    You must be logged in to view attached files.

You must be logged in to reply to this topic.