I started to run into some performance issue while querying data from our JIRA REST API. The API is paginated, and in order to load all required Jira tickets, it takes forever. I know that this is to be expected, but how do others solve this?
The caching option in Retool does not really solve this as the API is paginated. Or maybe I am doing something wrong?
Or, are you using another database in between (Retool and whereever your data comes from) to store the data?
I feel like I am missing something here.. Any help would be appreciated!
Do you know around how much data you're currently pulling into Retool? And where do you notice most of the bottleneck? Is your app slowest while the queries pull in data or is it after the data is already in your app?
Also, I'm not sure this will be helpful for you or if you've already seen it, but we do have this doc on performance best practices!
Thanks Victoria. Currently it is 20k items from Jira. The bottleneck are the API calls afaik. They are happening in sequence and sums up to a total of 15-20 minutes.
I have already seen your wiki article, but was not really helpful.
Do you have any other advice?