search

FriendsOfShopware / FroshPlatformMailArchive

This plugin allows you to archive your mails.
MIT License
17 stars 13 forks source link

database still filled after migration #98

Closed cbmod21 closed 2 weeks ago

cbmod21 commented 2 weeks ago

Question

we updated from shopware 6.4. to 6.5. after migrating the frosh mail plugin "frosh:mailarchive:migrate --sync" we hoped the database entries in table "frosh_mail-Archive" are gone. but the table still is 72MB.

how to fix this?

tinect commented 2 weeks ago

Sure, the database is filled with data, but not with the entire EML, is it? The HTML is currently also saved, but we are thinking of changing it, too. But there is no issue so far.

Why is it an issue for you to have a table with 72 MB?

cbmod21 commented 2 weeks ago

thanks for the fast answer. there is no real problem, but we did not see any shrinking of database table after migration. we hoped that the migration would free up space in our database since the frosh_mail_archive is the biggest table in our shop. the smaller the database, the faster are dumps etc.

shyim commented 2 weeks ago

I would ignore for the dumps the table :)

tinect commented 2 weeks ago

Is your message consumer running? they are migrated by the messenger. you can verify the eml column is empty.

cbmod21 commented 2 weeks ago

the eml column is indeed empty