Dear experts,
I imagine that as you develop, you may have noticed that the processing time for your data (when saving changes in the editor) increases as the size of your apps grows. I ask myself, “What is the cause of this?”
I’ve come up with some answers and have acted accordingly, as dealing with the bottleneck of waiting after each save becomes quite frustrating.
• First, I minimized the use of virtual columns (I hardly have any).
• I created a system that saves expressions in real columns, which are calculated once when the form is opened, and instead of writing them directly in the show ifs or valid ifs, I reuse them. In other words, instead of writing them 50 times, I write them once, and they are calculated once, avoiding unnecessary recalculations. I don’t know if it’s a coincidence or what, but I’ve managed (contrary to what my reason suggested) to achieve significant reductions in save times when making changes in the editor.
Do any of you have any ideas about the factors that influence data saving, and what can be done to make the process more manageable as apps grow?
LinkedIn
Twitter
