Speed ​​of use of an app according to the number of users

[Gustavo_Eduardo]

Hello friends, I want to ask you, based on your experience, what is the maximum number of users that is recommended to have in an appsheet app so as not to slow down its use. I think it can go fast at first but over time it can slow down. Tell me if I'm right and how many people would you put at most.

Thanks, good day!!!

[Rafael_ANEIC-PY · Accepted solution]

Hello @Gustavo_Eduardo, the number of users is not a factor in performance, but the data that is loaded and all the calculations that are made with each sync.

That means that an app which takes a minimalistic approach on the use of virtual columns and expensive expressions will be able to use thousands of rows easily without slowing down.

[1minManager · Accepted solution]

Hi @Gustavo_Eduardo I've had an app before where it was used by over a 1000 people on one particular day.  The app didn't slow down.  Though it was a read only app.

If the App operates slowly, its likely to be virtual columns and/or very complex or ineffecient formulas.  If it takes ages to sync it could be all those plus the users internet speed.

[Steve · Accepted solution]

Your question is impossible to answer. The performance of your app is entirely dependent on the complexity of the configuration, the size of the data, and the capabilities of the devices the users are using. There are simply too many variables.

[SkrOYC · Accepted solution]

En general hay una idea de que los Select, Filter y sus equivalentes (como Lookup) analizan toda la tabla a modo de "fuerza bruta", por lo tanto es mejor evitar su uso, sobre todo en columnas virtuales.

Los ShowIf no sé si impactarán mucho considerando que no afectan los datos sino la UI. Esa es otra área en la cual no hay un consenso al respecto

[SkrOYC · Accepted solution]

Actualmente me encuentro analizando conceptos de Clean Code que creo ayudarán acá.

Desde la forma de nombrar las columnas en el worksheet al tipo de funciones usadas.

Te recomiendo echarle un vistazo

[Anthony_Nel · Accepted solution]

Hey Gustavo,  In my experience things get really tight when using G-Drive and G-Sheets as  a data source and you go beyond 50 users or so and do lots of image uploads and or complex queries. I put delays in my automation steps to mitigate G-drive / Appsheet server timeouts , but you really need to use a high performance data source if you want to scale your app.