Skip to main content
Known Participant
Feb 14, 2025 11:36 AM UTC
Question

Does Looping API Calls Affect System Performance?

I am working on a process model where I use an integration to call an API. The API contains about 82,000 records, but it returns only 100 records per request. To retrieve all the data, I use a loop. After each API call, I save the 100 records using a record type. Does this slow down the environment if I delete the instance after every successful run?

7 replies

stefanhelzle0001
Brainy
Feb 14, 2025 11:46 AM UTC

I do not consider this to be a platform performance risk, but it might still be a good idea to run this in non-office hours.

Known Participant
Feb 14, 2025 12:34 PM UTC

Our server's CPU is at 100% usage. When we raised a ticket with Appian, they pointed out that one record type is taking too long to load, which is slowing down the UI. The UI uses a read-only grid, and the performance of the record type is causing delays. Could you please suggest ways to optimize performance and reduce CPU usage?

stefanhelzle0001
Brainy
Feb 14, 2025 2:29 PM UTC

Is your question about UI, or your syncing process?

Do you have a specific reason to implement your own syncing logic instead of using the standard?

This might be a starting point: https://community.appian.com/success/w/article/3402/analyzing-performance-issues