Synced RecordTypes or Unsynced RecordTypes (Disabling sync and features) or DataStore Entities(CDT)

Question

I have asked two developers about the best approach for data management in Appian. 
 One usually uses Datastore Entities and other uses Sync Recordtypes. But, I have seen that there is a third configuration where a RecordType is related to a Datastore Entity (this disable recordtypes relationship). 
 Which best approach is my dilemma. 
 I have heard recordtypes limitations related to database (some datatypes capacity limits) schema, 2 millions rows storage limitation and sync issues. 
 I haven't found documentation about best practices for data management. 
 What do you recommend? Some prefers CDT others Recordtypes.

Kalpesh Gujrati · Answer

Hi Darwin Pou , 
 In the video at 02:02, they discuss the Source filter (also known as the sync filter). For more information, refer to the below documentation. 
 Records-filter-source-data 
 For more comprehensive information on data fabric and its usage, please refer to the documentation below. 
 Data-fabric

Mathieu Drouin · Answer

Take a look at this which explains the benefits of using synced Record Types. 
 docs.appian.com/.../about-data-sync.html