Today, I would like to share a problem of performance. I have 2 tables :
- Client : composed of 3 fields (mail, temporary password et building)
- Building : composed of 3 fields (name, street, city)
Obviously, I dont count the id field from the both table. I use some API request from an external frontend. I would like to retrieve the city of the customer’s building. So, currently, i’m using 2 GET request. Firstly, to pick up the id of the customer’s building, then put it in the second fetch request to get the city.
You are agree with me that it’s not the best way. So I was wondering if it exists a process such as “relationnal table” to do whole this process directly in one GET request ?
Thanks in advance