In my app i am creating a dynamic calendar from first-principles.
I have a repeating group with each cell representing a day and logic setup to fully mimic a calendar
For each day I need to retrieve two data types, and there are 3 Time-slots per day. These dont necessarily exist for all days/time slots; the searches can return empty. The first time I built the page, I put “do a search for”'s in each cell. That adds up to a whole lot of “Do a Searches” on page load and every time the month is changed. It is also a search in the datatype with the largest entry count.
This felt very dumb, because all the do a search for’s are very similar (eg, Date is only a few days apart and Time slot is between 1-3). Why was i making bubble do all these searches? I realised i could just make one query by searching all Dates in a particular month and all time slots. With a single search i would have all the data i need to display on the page in a list. But after that what? I thought about using client side filtering to filter from the full month data list the individual day data. They are simple filtering actions (Date=Date, Time slot=1-3) on a relatively small list (<90)… but there are around 100 filtering actions (6 per day-cell), so that doesn’t feel right.
I feel like both approaches are not optimal… i’ve been stumped all day. Which one should i pursue? Is there a third option which is better and i’m not seeing?
Have a great day and thanks in advance