Hi all,
I want to ask about the difference between "write data entity" and "write record".
As an example, I have to store information in the database on 3 different tables, and I am using the "write multiple data entity" option.
which would be the most optimal performance in these cases, 3 "write records" or "write multiple data entity" with 3 transitions?
Discussion posts and replies are publicly visible
Hello, We can decide this based on our requirement where we are going to use the smart services to write the data.
we use Write to Multiple Data Store Entities Smart Service writes multiple CDT values to multiple entities within the same data store where you can update multiple entities within a single database transaction.
We can use the Write Records smart service which easily insert or update data in your source system and then automatically sync those changes in Appian. We have multiple advantages of data sync.
please refer this link for more info and based in the requirement we can decide on which one to choose:
https://docs.appian.com/suite/help/22.1/records-data-sync.html#benefits-of-data-sync
The write to multiple data store entity is probably slightly faster since it doesn't have to manage the sync. That being said, there are significant performance gains when querying data in synced records vs unsynced since you can get all the related record data in one go vs doing multiple queries.
Furthermore, I would assume that the difference in performance between the write to multiple DSE is probably negligible/small compared to 3 write records run in parallel.
Records are the future. CDTs and data stores are legacy.