Hello,
I noticed in my DB a lot of CRED Auto Draft in the post table of my website.
Yesterday, around 400 new entries were added and I can count more than 2000 in total. I have 1 or 2 new real entries per day.
I have a button on most of the pages of my website to ask visitors to add a suggest about the website. The button display the CRED form thanks to a modal.
I've seen the previous post : https://toolset.com/errata/cred-auto-draft-posts-accumulating-in-wp_posts/
I don't know if it's a normal process to create all of those drafts but my website has a lot of visitors per month, so I'm looking to optimize everything. I noticed that in 1 minute, I can have sometime more than 10 new drafts.
Auto drafts are created whenever a form is loaded on a page, this is an internal process which is needed to prevent duplicate form entries in the system (just like WordPress core). Since you mentioned you have a high traffic website with forms on almost every page, it is likely to happen.
Usually if a user does not submit the form, these unused auto drafts are cleaned up after 24 hours by an automated process in CRED (cron job). This 24 hours time is calculated from the time the auto draft is created, so there can be left overs for more than 24 hours (i.e. an auto draft was created in less than 24 hours at the time the automated cleanup job runs, so this 'll be caught in next-run).
In short, if you see that auto drafts are not just growing up, but also being cleaned up (i.e. variable count every day, sometimes less than the previous one), that means the job is doing its work and there's nothing to worry about.
However, if the count is only growing ever then we need to look into the matter.
I'll suggest to keep an eye on this for a few days and see what's happening. If this is only growing always, provide the debug information of your website for an overview of your setup. Please see https://toolset.com/faq/provide-debug-information-faster-support/ for more information.
I've enabled the debug information section for your next reply.