2.0.6.102_canary_2022-04-06 index additions add a chance, but no guarantee:
Improved database query performance, thanks @jedthe3rd
Add indexes to improve backup query performance #4687 was the code change.
Identified another slow query during backup was related discussion in the forum.
You can see the focus was backup, but indexes might speed SQL in other ways.
The cache_size change is also kind of a generic tool not specifically for compact.