A common scenario that happens after you go live with your dashboards is to have several dashboards that have a large number of filters available for the viewers.
This is a potential issue as the more filters you have in a dashboard -> the longer it takes for queries to be processed.
The Query Optimizer plugin is here to solve this exact performance issue by intercepting all queries and dynamically re-structure them so they'll show the exact same results but with a much faster processing time.
By using this plugin, you can expect a significant improvement between 10%-75% reduction of the queries processing time.
The performance boost mainly depends on the amount of filters you have within your dashboard and the complexity of your data model.
This optimization will significantly help your dashboards to get loaded much faster and simultaneously reduce the amount of resources that your server requires to operate.