Slow Chart Load - how to speed up?

tjc4 · 2020-12-03T21:37:07.038Z

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.

image1460×466 28.7 KB

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.

sylvainn · 2021-07-29T13:37:20.455Z

Same problem here.

Did you find a solution?

tjc4 · 2021-07-29T15:47:21.622Z

no solution. if you find one, please update this thread as I’d like to know. thanks and good luck!

jared.gibb · 2021-07-29T16:04:00.995Z

Shouldn’t take that long. Have you tried other chart plugins? Mine may be a a little hard to figure out at first but is definitely faster than that!

sylvainn · 2021-07-30T10:05:41.750Z

You have this thread that can help you also:

How to detect when chart is loading? Need help

Yes the chart element loads instantly, but it is the searching for data that takes time. I have created a test app where you can see that how my way could work. (Notice the condition on the chart and spinner element) I also struggled some time ago with this problem, but there is definitely a solution! Demo: https://chartloadingtest.bubbleapps.io/ App editor: https://bubble.io/page?name=index&id=chartloadingtest&tab=tabs-1&subtab=App%20Data

tjc4 · 2021-07-30T13:37:21.418Z

yes, I’ve seen that thread and tried the loading thing. the issue isn’t the chart load but the data load. so my question is at its core another “why is bubble so slow?” question.

in response to these questions - there are a lot - bubble offers generic answers. they’re usually something like this: “bubble is fast enough; you just don’t know how to use bubble and you designed your database incorrectly”

it’s really frustrating and why I referenced the Bubble Manual that tells you how to structure your bubble database and described how my database is structured according to the Manual.

so why are my database queries so slow? I have no idea

my solution was to just remove this chart from my app. it was a nice to have but not critical feature. sucks but that’s bubble life

sylvainn · 2021-07-30T14:33:54.857Z

That’s a shame.
What I noticed it is when I activate “Do not skip empty groups” in Group by options that the loading time increases.

Screenshot 2021-07-30 at 16.32.09670×1226 60.3 KB

sylvainn · 2021-07-30T14:50:54.447Z

Hey Jared!

Had a look to your plugin. Looks great but seems really hard to implement.

jared.gibb · 2021-07-30T16:08:17.139Z

sylvainn:

Looks great but seems

Not bad once you get the gist of it. I’d be happy to help you set one up sometime if you wanted to plan out a zoom call.

I probably won’t make documentation for them because they’re free but will do some forum posts if someone has specific questions. I’d also add features as requested if they can be feasibly implemented.

I’m using a fairly complex custom timeline chart for one of my apps that I coded. Loads very quick. Slow load times are likely due to a lot of complex data filtering.

jared.gibb · 2021-07-30T16:12:44.506Z

tjc4:

database queries so slow? I have no idea

Because calls to the dB often require the server to be woken up. The server takes a second to “come alive” then does the search and then sends it back.

Using Firebase or another real-time database or just using a backend that doesn’t need to “be woken up” with client side (not server side) api calls would make your data retrieval faster for sure. It takes more work though to configure a plugin the way you need it.

sylvainn · 2021-08-02T13:53:54.919Z

Hi @jared.gibb
Would be great to plan a zoom call to set your pluggin within my app.

Please tell me in DM when you are available. I am based in France (UTC+2)

Thank you in advance!