Data duplication is definitely the archenemy of database speed. removing dupes typically relieves most database bottlenecks. if you want a consultant that could build and deal with custom made ETL pipelines that load https://www.ralantech.com/mysql-remote-database-consulting-services/