I am now working on some SSRS reports with Report builder 3.0. I built a datasource with CAML to query (and joined) data from SharePoint lists. In production environment there are over 50,000 records to be queried. I am worrying about the actual performance.
May I know the query process is actually occur at client side, SP servers or SQL servers? Could you please explain?