@skatterbrainz appreciated. Sadly this only seems to happen on the database that runs bespoke software that we paid a stupid amount of money for, and I am limited to only using certain views that the developers create…when I look at the design behind the view I can totally see why performance sucks, but saldy my hands are tied as I am given what I am given to work with. I also create a lot of my own databases, and always run direct SQL to UD from my own DBs and it works great…the dashboard in question I posted in the show off here:-
which is reading from CSV as the queries took to long, as you can see via CSV it was instant load.