Refresh cached filters takes a long time
Hello, we have hundreds of reports and several Client Orgs on our setup, something that users always complain is the time that it takes to refresh cached filters, sometimes you can wait for several seconds to minutes to refresh cached filters, even if the returned values are only a handful. Is there a way for us to optimize this?
We are currently on YF 7.1 20160418 Windows 2012, DB is SQL Server 2014 Ent.
This is not a recent issue, the same happened when we were on v6.3 and SQL 2008