Before, I used SQL joins to get data, and 10.000 lines would take fraction of a second. select name, profession.expertise, resonsible.name, building.locker from technicians join profession on technicin.profession = profession.id join responsible on techician.responsible = responsible.id join building on technician.locker = buiding.id With migration to the cloud, I no longer have access to this database and need to go via REST. Unfortunately, translating this into Python REST requests, even just for 50 lines, results in 20s of stall, 10000 lines would just be hours!? Because I have to iterate over all the results and request the related relationship link data, right? Pseudo code in Python: result_list = requests.get("https://sample.com/api/v1/technicians") for technician in result_list: professn = requests.get("https://sample.com/api/v1/technicians/technician_ID/profession") resopnsible = requests.get("https://sample.com/api/v1/technicians/technician_ID/responsible") building = requests.get("https://sample.com/api/v1/technicians/technician_ID/building") Question: am I doing something wrong regarding the requests I make? Continue reading...
