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.
Discussion posts and replies are publicly visible
hi Darwin Pou it all again depends on the data how much are you processing or querying into your application? My thoughts would be.
Smaller or Medium-sized Applications: Synced Record Types balance performance and ease of use.
Large-scale or Complex Applications: DSEs with custom queries and CDTs provide the most flexibility and control.
Mixed Use Cases: Using Record Types with DSEs can blend both approaches, but you’ll need to manage the relationships yourself.
Mixed Use Case. Do you mean unsynced recordtypes?. Do you have related documentation for developer?
I'm trying to test a Parent interface with a list and Child interface for CRUD.
This means that depending on what you need to do, you will use synced records, unsynced records, or DSEs with CDT's..
Unsynced records
With the way Appian is evolving, in my opinion using recordtypes makes your application future proof and also make your enviornment fit for Process HQ and other new features being introduced by Appian. Right now limitation is 4 million records. but with right filters you can sync lot more data. They have also planned to get the limit increased to 10 million.
In that context. Is there any documentation related to split up data in recordtype based on a date field just like it is explained in this video in minute 02:02 youtu.be/FvA3oezAVcg
Not that I have come across.
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
Take a look at this which explains the benefits of using synced Record Types.
docs.appian.com/.../about-data-sync.html
Hi. In sync recordtypes what are the approaches when there are several apps that need to access the same data? Write and read. How the concurrence is handled if data is synced in distinct data fabric. When data in an app is read and another is writting at same time, so the first one is obsolete?
In database design is called concurrency control.