I would NOT transfer the database contents to the client for the client to perform the query. The result of the query is much smaller than the amount of data needed to complete the query (Kayvon gave the example of making a local copy of all of Google's databases just to answer a single search query), so it's much more effective to compute the query server-side and just send the result to the client.
I would NOT transfer the database contents to the client for the client to perform the query. The result of the query is much smaller than the amount of data needed to complete the query (Kayvon gave the example of making a local copy of all of Google's databases just to answer a single search query), so it's much more effective to compute the query server-side and just send the result to the client.