Massively grown database

  • Resolved mominet

    (@mominet)


    1 year, 3 months ago

    Greetings,
    I installed the plugin on my website fantasvaimec.it,
    in addition to the Home Page, it is also present on this page:
    https://fantasvaimec.it/sport/

    just fetching feeds to show in backend, no posts to import.

    Only after a few days I realized that the database has grown X3 and the bulk is in wp_posts and wp_postmeta and the only substantial change in recent days has been to use Feedzy.

    Is this behavior normal? Even if it only shows the feeds does it still matter the posts? Will the database continue to grow dramatically?

    Thank you

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @mominet,

    Thanks for choosing Feedzy!

    Could you please provide us the steps that should be followed to replicate this behaviour on our test instances?

    Thank you!

    Thread Starter mominet

    (@mominet)

    Good morning and thanks for the reply.

    I don’t know what to indicate:
    simply on the site using the block editor I inserted the RSS Feeds in the Home Page and in this page:
    https://fantasvaimec.it/sport/

    In practice, immediately the database from about 5 MB has passed to about 15 MB and now it seems to continue to grow (we are at 16.2 MB this morning) despite having practically done nothing these days since the site is paused summer.

    Now I would like to understand above all why this happens and if the database is destined to grow indefinitely.
    The entries in the database that have undergone this growth are wp_posts and wp_postmeta

    Thank you

    Plugin Support Stefan Cotitosu

    (@stefancotitosu)

    Hi @mominet,

    Thank you for the clarification.

    When using the Gutenberg block or the shortcode approach of Feedzy to display feeds, they are processed directly from the XML URL by using a library and displayed on the page. If the source changes, the feeds displayed by Feedzy are also updated in this scenario. My point here is that Feedzy doesn’t save them in this scenario and it shouldn’t be the reason for the database growth; only if the feeds are imported as blog posts in which case they are saved, however, the database grows according to the number of posts imported. Each imported post occupies a similar space as a post manually created from the Dashboard.

    You can also try to temporarily deactivate the other plugins and switch to a WordPress default theme to see if it stops the database growth; this test can also be performed on a staging site.

    Regards,
    Stefan

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Massively grown database’ is closed to new replies.