Hi Arnan, we have the same issue in the 4.2.1 Pro Version, it still needs a huge amount of MySQL CPU resources and creates hundredthousands of records.
You mentioned a cleanup routine should be active in AdRotate Settings > Maintenance but it seems there is no cleanup routine setting which you can permanently activate, only a button for a one-time Database optimization.
Kind regards,
Marcel