Is there any limit on number of attributes that an Entity can have, I have a scenario where i am supposed to store values like multiple values like price, cost, etc like this there will be 30 items for each submission. These 30 items have a unique code that is maintained.
I was thinking should i create a table with submission form id, filed code and value or should i create a table that has 30 attributes.
Which will be better.
And also what is the maximum number of attributes that can be created for an entity.
Thank you.
Hi,
So far as I know, the limitation comes from the DB itself. Per exemple, Microsoft SQL Server have the limit of 1024:
You can check it here:
https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16
I belive that the problem, many times (not allways) we set an enourmous number of attributes in an Entitity because we have a bad database model. A bad design can leave us in that scenario, even when you need to have multiple values (many times, the best is not to have that multiple values in the same table,with the problem that they are static, if there are 30, stays 30, you can go to 31, and the best way is to go to a may-to-may relation).
In this case normally I look to make the model based in 3NF:
https://www.geeksforgeeks.org/third-normal-form-3nf/
Ehit that you can reduced data redundancy and storage space, prevent data anomalies and improve query performance.
Hope this can help.
Best regards,
Ricardo
Hello
There is no such limitation as far as I know, it depends on the requirements, I had an external DB integration with more than 100 attributes we have to sync those here,
And if you try it yourself and find out it is working perfectly or not that would be the best solution.
ThanksTousif Khan
Hi @SANTHOSH PRINCETON
As there is no limitation but I would suggest create submission form,filed code and value instead of creating 30 attributes.
Thanks
Arun