I want to get incident table data for 120 days. I want to show the front end into chunks like 1-7 days, 8-20 days, and so on. Also, want to group by created_at and updated_at.
What is the best approach to get data from the service now? Should I query multiple times with a small date range or one query with a large date range like 120 days? Also, should I send the created_at and updated_at in one query or two different queries?
FYI(table has millions of records)
