Issue with email queue and database size?

kolate_sambhaji · December 23, 2017, 8:54am

We found database size is increased with increase in email send.
Currently we send 100+ ( less than 500) email with image and pdf attachment. The database size is showing 1.2GB

Is this normal?

revant_one · December 23, 2017, 10:22am

I think email queue doctype stores attached files as base64 encoded data into database.

kolate_sambhaji · January 11, 2018, 1:54pm

Hello,

I got one client server to retest this issue.

Database size is 3GB.
If I delete email queue then database size is 207 MB

Is this fine if I delete Email Queue?

Thanks,
Sam

saravana · May 30, 2021, 6:40pm

@kolate_sambhaji. Did you delete these Email Queue records?

Is this API, frappe.delete_doc() sufficiently deletes the records?

Thanks,
Saravana