Very slow app, despite several optimizations, an opinion?

Need help
1

Morning, everyone,

I have a crucial problem of slowness on my website as soon as I overtake several users connected at the same time.
My app is like Tinder (Like/Dislike/Matched), the heart of my app is a HomePage with a repeating group showing the users that can be liked or disliked, which moves to the next one. Inside this repeating group I have another repeating group that refers to a Database with the user publications.

I built the Like/Dislike system and filtered my repeating as much as possible with constraints, used api workflow, etc… to make my app as fast as possible.
I guess the problem comes from the constraints to not show users that have already been liked/displayed that are a “List of Text” with “doesn’t contain”.

Here’s a link to the editor for what you’ll be interested in looking at : https://bubble.io/page?version=test&type=page&name=homepage&id=cersobackend&tab=tabs-1

Do you have any recommendations for optimizing my Database, repeating group, etc?

Thank you very much for your help !

2

Hey!

Very nice app!

I tested it on my side and taking into account the personal plan and it works fine :slight_smile:

One thing I noticed is that you can also connect created project with the User by creating on data type User → field List of Creation/Projects

then you could have Data source Current User List of Projects which should be faster (rather than having another search in image below)

image
image1337×598 123 KB

You think that this search makes your app slower?

image
image747×722 71 KB

3

Thank you @bartek.dev ! I will take the change,

I think indeed that this constraint poses a problem, I removed it and it’s faster, the problem is that I don’t find any alternative.

4

Remember to also change it in the workflows.

The way app works - I think that is the only way it can be structured. You can experiment with Search For Users:until item X. But it will probably be faster only on the first load.

It should be faster with the projects connected to the user directly. Do the changes and let us know if it’s better.

5

This topic was automatically closed after 70 days. New replies are no longer allowed.