Currently each trend takes a considerable amount of time to load up, from 8 - 15 seconds. I’ve reduced the amount of data from 4,575,000 to 1,750,000 rows per monthly partition. This looks like it has reduced the load time slightly but no where near enough as I’d like. Are there any other methods/techniques I could use to reduce load times? My customers require hourly/daily/weekly/monthly reports.