Hi everyone,
Given Bubble’s 2023 pricing, I decided to use Xano as my backend, which I’ve started implementing in my Bubble app.
So far, my Bubble app is extremely slow when using Xano API calls, so I’m guessing the problem comes from the logic I’m following with my API calls.
I’m building an e-learning sort of app, where users can take various courses in various categories, and keep track of their progress through the course.
My Xano tables:
User
Category
Course (linked to a “Category”)
Unit (linked to a “Course”)
Lecture (linked to a “Unit”)
Part (linked to a “Lecture”)
Progress (linked to both a “User” and a “Part”)
Given this normalized structure (as opposed to a denormalized one), I have retrieve data bottom-up:
Who’s the user?
What’s the latest “progress” entry that belongs to that user?
What’s the ”part” corresponding to that “progress”?
What’s the “lecture” corresponding to that “part”?
Etc… (all the way up to the “category”)
This induces a lot of API calls, and my Bubble app is way slower than if I use a similar logic in Bubble’s backend.
What’s the ‘correct’ way I should go about this? For example, should I retrieve all the data on pageload, somehow store it somewhere in Bubble, and then display it? As far as my beginner’s eyes can see, it seems way too demanding to make an API call each time a value must be displayed somewhere, or every time a Bubble condition has to be performed…
Looking forward to your guidance!