two tables stored on the DB server. I need to join these two tables and perform further calculations. I am sure that the calculations part should be done on backend server. But I am wondering if I should perform the join in the DB server and then bring the new table to the backend or if I should bring the two tables to backend and there perform operations replicating join (using ADO.NET) before continuing with the further calculations.
- Tables have few millions records.
- It will be great if you provide some references to support your answer.