Lists in options sets and performance

If I have categories, subcategories and modalities in option sets.
In categories I have a list of 200 subcategories, and in subcategories I have another list with 200 modes.
I’m displaying this data in repeating groups on the page (repeating group categories, repeating group subcategories, and repeating group modalities).
Question 1:
This way of building using large lists in options sets can harm the application’s performance when being used by many users at the same time?
Question 2:
Is it better to keep this way using option sets or build tables in the database?
Thank you very much

@mayara.sacboticario Option sets are the fastest alternative as of performance they are static lists. Bubble says “Option Sets allow you to have a static list of choices, “Options”, which are global to your app. This is great for situations where you know ahead of time what options are possible for a variable”.

So, if you already know what they are going to be, it’s your best option. Tables are better if you’ll need real time updating.

2 Likes

Thank you

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