Hi, looking for advice/best practice on how we can improve our daily load.
Currently we have a couple of sql/datareader updates in our daily load which individually consume up to 10 minutes each. In total our daily load needs more than an hour, which is too long.
Most of our reports in Board are based on monthly figures, our setup for these datareaders at the moment is that we reload historical data (2015-2019) for reportings everyday. Is it somehow possible to load the historical data once and after that somehow define that only the last 3 months are updated daily. If so can I do it in Board or does it need to be done in the SQL server.
What kind of setups are you using for daily updates?