Hello, im currently in the progress of creating an app for a clinic work purposes. Im new to this and need your suggeston on how can i structure my data efficiently.
The app im creating for a clinic work purposes has many different subunits so i plan to have a many-to-many relationship for the app. I plan to separate all the units into a DIFFERENT SPREADSHEET and not grouping it all into 1 or 2 spreadsheet.
What i want to ask, if i plan to do it this way, will it affects the efficiency of the App, the speed of the app, the reloading time to update all details and database etc.
Or is it better for me to combine all units into 1 or 2 google spreadsheet?
Another concern, for future proofing, since it will be use for clinic work purposes, the data entered may be of large amount after some time.