Let’s say I have three products. one is my database, accessible through SQL , a GraphQL server, and a webApp GUI to access the information of interest.
As an example i will say that people around me are interested in the vegetables market.

So I use to do queries in SQL, to fetch the data into my webAPP. Everytime I use the “search” and filter by “fruit_color”, it will do all this in the client side.

On the other hand GraphQL can also fetch the data doing all the filtering in the server side and retreiving exactly the amount of info required. so no client side filtering process involved.

In this case I am going to look into the performance, since it is a guide but maybe before all this chunk of code and lines goes live, does anybody faced the same dilemma ?

what is best practice currently?