I mentioned this to the dev long time ago, and their response was to re-create a new database.
This is not an option if you want to keep track of your sale records, buyers info, and many other things, etc.
I have 100K+ completed items in less than 1 year. 99K+ are “not sold” and are in completed.
My suggestion was to create an option to remove unsold completed listings 90 days or older, or some sort of option to remove prior of x date of your choice.
this keeps the database clean and less junky.