You are given a list of VM_Vehicles Custom Data Types. Which smart service offers the best performance to write the values to the database?

You are given a list of VM_Vehicles Custom Data Types. Which smart service offers the best performance to write the values to the database?

• A. Write to Data Store Entity
• B. Write to CDT
• C. Update data in memory
• D. Delete from data store

Answer: (A)

Writing to the database in Appian happens through a Data Store Entity. A CDT represents your data in memory, but to persist it you map it to a Data Store Entity and perform a write operation. This path goes through Appian’s persistence layer and translates into efficient database statements, often enabling batching and proper transactions. Updating or manipulating the CDT in memory does not persist the data, and deleting from the data store removes records rather than writing new values. So, when you have a list of VM_Vehicles to persist, using a single write to the Data Store Entity (passing the list) delivers the best performance by minimizing round-trips and taking advantage of the database’s optimization.

Writing to the database in Appian happens through a Data Store Entity. A CDT represents your data in memory, but to persist it you map it to a Data Store Entity and perform a write operation. This path goes through Appian’s persistence layer and translates into efficient database statements, often enabling batching and proper transactions. Updating or manipulating the CDT in memory does not persist the data, and deleting from the data store removes records rather than writing new values. So, when you have a list of VM_Vehicles to persist, using a single write to the Data Store Entity (passing the list) delivers the best performance by minimizing round-trips and taking advantage of the database’s optimization.