Stop Treating SharePoint as a Database - It Will Eventually Bite You
SharePoint Lists are brilliant for what they're designed for and actively dangerous past that scope - and the limits bite when your solution has been accumulating data that matters.