locked
Attributes in CRM RRS feed

  • Question

  • Hi Experts,

    Max number of attributes that can be added to a entity is 1000 which means having 1000 columns in a particular table.

    In our current project implementation [already live] , we are having case entity with 400 attributes and recent new requirements will make it  touch 600 attributes.

    Just curious to know if there is any impact re attributes !!

    Thanks and Regards,

    AJ

    Monday, November 25, 2013 11:22 AM

All replies

  • Hello,

    Surely there will be small impact on performance when fetching data in plugins/reports/entityforms.


    Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Monday, November 25, 2013 11:33 AM
    Moderator
  • Hi Experts,

    Max number of attributes that can be added to a entity is 1000 which means having 1000 columns in a particular table.

    In our current project implementation [already live] , we are having case entity with 400 attributes and recent new requirements will make it  touch 600 attributes.

    Just curious to know if there is any impact re attributes !!

    Thanks and Regards,

    AJ

    Monday, November 25, 2013 11:36 AM
  • Hi,

    I would first say that adding so many attributes to the same entity is definitely not a good practice and should be considered for proper architecture.

    Better to have a couple of discussions to rethink for how you can break it into sub-entities to have a classified structure.

    Moreover if you add so many attributes to the same entity, then you will be requiring couple of plugins or some temporary fields to store and utilize those fields. If you reach the threshold by the required fields only then what you do when you will need more fields to carry out operations for existing fields.

    As an addition, consider retrieving large amount of data will be degrading the performance of the whole system. 

    I hope this helps.

    Thanks & Regards,


    Anubhav Bajpai


    • Edited by Anubhav Bajpai Monday, November 25, 2013 11:48 AM Updated performance
    Monday, November 25, 2013 11:44 AM