the Business Intelligence guy is asking for faster machines, latest software etc. and some of his customers are complaining of query times in excess of an hour. The tool is Cognos/Insight and the DB is replicated copy of a master MySQL which we are shortly to migrate to MariaDB.
My gut feel ( before I get down and dirty with the SQL and Execution plans ) is that we are simply dealing with poorly optimised querys coming out of Cognos and an inappropriate collection of indexes to support them.
My Question is ( before I bespoke a solution ) : Are there accepted strategies for realtime slave tables that allow for indexes that are not present on the master table?
Aucun commentaire:
Enregistrer un commentaire