Most Calcapp apps have tens or hundreds of fields. Some of you, though, build truly ambitious apps, with thousands of fields and formulas. Recently, one of our customers showed us an app with more than 8,000 fields spread over four screens, almost every one of them with a formula of its own.
Calcapp Creator struggled with that app. Opening it took a minute and a half, and moving to one of its screens took just as long again. Using the app designer with an app like that was close to impossible.
We have worked on the performance of large apps before. We made Calcapp Creator faster, made apps load faster, made editing large apps smoother and made large apps download and start faster. It has been a few years, though, and apps have kept growing.
What happened?
We expected to find one big problem. Instead, we found three smaller ones. Each one was harmless in a typical app, but grew much worse as the number of fields grew. Two of them were in Calcapp Creator itself, and the third was in a third-party code library that lets you rearrange fields by dragging them.
What we changed
We fixed all three issues. The app that took a minute and a half to open now opens in a few seconds, and its screens appear in a few seconds too. Editing formulas and labels was already fast, and it remains fast.
If your apps are of a more typical size, you may not notice much of a difference. The larger your app, the bigger the improvement.
These changes apply to all apps, and you don’t need to do anything to benefit from them.
How large can an app be?
Our pricing page lists the White Label plan as supporting apps with up to 5,000 fields, the most of any plan. Our other plans enforce their limits, but White Label does not: in practice, it is unlimited. We couldn’t in good conscience promise that apps of any size would work well, though, so we list 5,000 fields, the largest number we were confident in.
Do you need all those fields?
Many of the largest apps we see have something in common: thousands
of hidden fields, each with a formula of its own, often with names
like Counter1234. With older
versions of Calcapp, that was frequently the only way to get the job
done.
That’s no longer the case. Calcapp now has first-class support for arrays, which let a single formula work with many values at once. Functions like FILTER and XLOOKUP find and pick out the values you need, and named values can hold whole tables of data without a single field.
Rewriting an app this way often reduces thousands of hidden fields to a handful of formulas. The app we mentioned above could have been rewritten to work well even with older versions of Calcapp Creator. A smaller app is also easier to understand and change, and it starts faster for your users.
Let us know
If Calcapp Creator feels slow with one of your apps, please let us know. Your reports make Calcapp better for everyone.