Hi all,
I have an issue with loading a lot of search data efficiently.
Basically I am trying to provide data points (numbers) for a graph for each month (Jan, Feb, etc) that come from the bubble db.
I know that server side loading is quicker than client side so I went for 12 “searches” like this pic instead of one search and client side date filtering.
The reason I multiply by 1 is so I can get 0 instead of empty if there are no Activities that month.
It currently takes 5 secs to load this graph. I would love this to load in like 2 secs if possible. What changes can I make to achieve this?
For reference, here are the relationships between the relevant data types:
Disregard “_linkeduserId” as that relates to something else