Advice on database structure in Appsheet & Google Sheet

[drfuadj]

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.

[Marc_Dillon · Accepted solution]

If the records are all of the same, or very similar, "thing"... they should all be in the same table.

Utilize Security Filters to only load subsets of data into the app at once.

https://help.appsheet.com/en/articles/954497-security-filters-the-essentials

[drfuadj]

Thanks for the link source. WIll read more about that. Thanks alot