I’ve got a chart that displays the current user’s count of Answer things grouped by creation date. It takes over 6 seconds to load (on Personal plan) despite the current user having created only 35 Answer things.
Here are the chart’s inputs:
The Bubble Manual has a section on connecting types with each other that offers three options for database design. I’m using the approach Bubble describes as Option 1+2. I could try Option 3 but that’s recommended when you “expect one thing to have a list of more than 100 values”.
With only 35 records I’d expect Option 1+2 to have much better performance. I’ve done some testing and the loading of this chart seem to scale linearly so at the 100 record threshold this chart would have a load speed of roughly 20 seconds.
Am I doing something wrong? Any advice would be appreciated.