I have a report which is sloooow - seems like a good candidate for summary index. reading the docs it suggests configuring a saved search to run on an hourly basis to populate the previous hours data.
This dashboard panel will then show a months web transactions.
but how to set this up initially .. should i create a scheduled saved search to initially run over a month timeframe to initially populate the summary index - and then reconfigure to run hourly - or what ?
You can check following approaches for faster reports:
2. You can also use accelerated data models:
3. Scheduled Report
4. Summary indexing.
Let me know if this helps!!
You would schedule it to run per your desired frequency, i.e. Hourly, to summary index data from now on. Then you would backfill the summary index for the desired duration, constrain by amount of raw data you've available. The backfill process can be found here:
The backfill can only be done for period you've actual/raw data available. The backfill period should be just before you scheduled it run.
Short answer would be... both
Slightly longer answer depends of whether you want any historical data to work with/how long it will take to run the search over a months worth of data, or if you're happy to just populate with data from the time you click go
I'm assuming you've done everything you can to optimise the search you have, if that's the case then summary index is definitely the way to go