Loading too slow > How do I improve this data pull expression

Hi- I have a data pull that is loading about 20 seconds slower than the rest of the page. How would I improve this expression:

This is what I am trying to achieve: How do you set up this expression to capture the latest data by each person? - Need help - Bubble Forum

Hi,

I saw the earlier list you posted and how you wanted to calculate the sum of desired fields.

How are you managing color code it to “red”? so far with current structure I assume you’re using conditionals. I would suggest create a colorcode field in your datatype and once the field has red color then add the sum in variable to improve data loading.

Let me know if you need more help! and hire me to fix the issue.

Filtered works much slower than a pure ‘do a search’, as all the data has to be loaded out. It may be better to precalculate/store the values you are trying to show into a separate table so that you can do a simple search to pull out the data you need.

The tradeoff is that you have to calculate the change after every new entry.

ya- i think this is the best approach. I was debating on adding the latest data onto “User,” but tried to avoid it b/c “User” dataType gets too many data fields. I think your proposal is still the cleanest approach.

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