I am creating an application for which many attributes need to be stored, and it will look at the DB while running (This means that many DB lookups). this app. Should be less overhead, I need your suggestion to make more than one column in a single column or to create multiple tables with the minimum columns.
Having several tables does not actually add your app to any upper part, and If any, then it is actually dwarf, you can get the relational database design points and benefits from the good organization of data.
Also, consider what type of data you want to store, for example, if you are collecting the customer and their orders, this does not mean to keep all this information in a table Or, you can, but it would be denormalized and in this case you will be doing additional work to organize the data in the code and add unnecessary overhead and storage usage.
Comments
Post a Comment