heavy tables for mailpoet

  • Resolved effi

    (@effi)


    2 years, 12 months ago

    hello
    I looked at may databases table weight and found some surprising weight for thes 3 tables 

    wp_mailpoet_newsletter_templates
	93 lines 		8,2 Mio	
wp_mailpoet_scheduled_tasks	 	 2269 196,7 kio	-
wp_mailpoet_scheduled_task_subscribers  20131  1,4 Mio

    can i delete old scheduled tasks to reduce the weight
    why is it not done automatically when status completes ?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Gui A. a11n

    (@guicmazeredo)

    Hi there @effi,

    Thanks for reaching out!

    Old scheduled tasks are not deleted because they are still used for other purposes (statistics).

    The size of database tables depends on how many subscribers you have and how many emails you send. Also, modern database systems are designed to handle many times more data than that in a performant way, and MailPoet has been designed to make use of such features to have little to no effect on your site’s speed.

    Are you experiencing performance issues on your site? Can you tell us a bit more about it? When or what steps you have to perform to notice the performance issue?

    Thread Starter effi

    (@effi)

    hello
    thank you for your answer,
    yes my hoster warn me that i used too much resources, so i looked what can be the origin, and when i saw these large tables with only messages “completed” for each day i asked it on the forum

    Plugin Support kellymetal a11n

    (@kellymetal)

    Hi there @effi,

    Thank you for the information.

    We have some info about what should be expected with database usage in our documentation here:
    https://www.mailpoet.com/faq-mailpoet-performance/#faq-question-1583500223797

    As mentioned though, since the old records are used for statistics, deleting old data would likely cause unexpected behavior + inaccurate stats.

    I see there’s an open request for additional options for deleting old data / database optimizations on our feedback board here — it would be great if you could add your vote there to show your support for the request:
    https://mailpoet.canny.io/feature-requests/p/database-optimisation

    Please let me know if you have any questions. Thank you!

    Hi there @effi,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘heavy tables for mailpoet’ is closed to new replies.