Hi All,I have record type which is configured as a service backed record using an expression rule that call an integration to an external system.Additionally, we have configured the schedule full sync at 12 am daily. I have few queries regarding this:1. Since the record type is service backed, does Appian store any data internally when the scheduled sync runs?2. will a!queryRecordType() always hit the external system even after the scheduled job runs?3. If data stores internally, does appian consume memory? if yes how much?4. If it hits external system every query, what is the recommended approach if we want to avoid repeated API calls and Improve performance?Any guidance or best practices would be helpful.Thanks in advance
Discussion posts and replies are publicly visible
You answered this question already in the second sentence:
appalasurip0001 said:full sync
1) Yes. This is what a synced record is about.
2) No
3) Yes, and depends on the data you store.
4) N/A
Answers for your queries:1. When sync is enabled, it will cache the data in appian.2. Nope, it will get the data into appian cache memory at scheduled sync/manual sync, you can access it directly w/o explicitly calling API.3. Internally in the sense, data is stored in cache, upto 50 million records, but need to batch the records by 1000(Incremental sync is recommended).4. As it will not hit, There is no approach for that.Hope this helps you understand clearly....
Yes, Appian caches synced data internally in Data Service.No, uses cache unless stale/missing.Yes, proportional to data volume.Enable incremental syncs, filter queries, monitor cache; consider DB-backed.