considering SQL database hosted in cloud…what is the better:
Have
a lot of fields: ENUM populated with VARCHAR and save varchar in database (sync time in better because the Appsheet server fetch less tables in data source, but database size is bigger (the same VARCHAR is stored thousands times and maybe processing time is less…and cloud storage is more cheaper than processing, but with enums the maintenance can be complicated to delete, update items etc)
Or use a lot of ENUM TYPE REF (filled with valid if of a TABLE) and save int in database and maintenance the database short but maybe increase processing time?
In the cloud we pay for CPUs, storage and bandwidth…help!
LinkedIn
Twitter
