@ErikDarling A charide, Morning all! Yes, partitioning can be a Godsend!
This is a bit of a long one, but I used partitioning to turn a 25 minute query in a 5s one - not too shabby. I would agree that not being able to have a UNIQUE index across partitions is not great - but hopefully on the way - much work has been done in previous recent releases to bring it up to scratch.