I would run the import as a job in the background with another API to have a progress bar of sort whilst it is being read and then processed. That way it is scalable by adding as many jobs as necessary.
Best performance for Multiple API request
Hi guys, today i'm develop an API on specific one method that recives an CSV with a lot of data, as name, street, country, email, phone, etc... and the logic is simple, read file, insert on my DB and then create json like {'name': 'Jhon', ...} to send another API to get a response, but i start with 40000 rows, so ... First when user request my method, need start process csv, but return a quickly response, to then the user recibe an email or check the process status with another method. Second need process multiples csv calls, so need my server dont die on process that data.. What do you recommend?
Please or to participate in this conversation.