I am absolutely greatful for all your replies, as it has given me confidence to proceed my project in adalo.
Although i do see i will be facing some performance difficulties at the point of stress testing. I will try my best, keep asking for additional support and hopefully share my experience on the used approach.
I believe that this type of project, in order to succeed… we need to face the fact that every feature and every process needs as much attention as any coded application. Disregarding the fact that a nocode application is a means for rapid development. I will share my thoughts as the project heads closer to completion.
Thanks you all for making this post an actual discussion of what is expected in a platform like Adalo, and for sharing experiences that could help many people from here-on.
For more opinions and examples of real apps checkout this post: Performance updates - Help - Adalo