Memory issue/ random occurrence error when retrieving data from ext API
Options
![Xano Support Chat](https://us.v-cdn.net/6037124/uploads/userpics/FKYXLB95T7IC/nMGWYAJV7MBEL.jpeg)
Xano Support Chat
Administrator
ADMIN
I am trying to pull data from one of my APIs and then insert it into a table. This pulls 200 records per API call and it may have 20000 records. But I keep getting this error:
Best Answer
-
We see your CPU, API requests, memory and function stack overall don't seem to be maxed out. If you don't need the data with the typical quick response of an API endpoint, the best way to process the volume of records you want to work with would probably be using a background task as they have dedicated resources to run the data. That way it won't affect your instance.
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback