I need to know advantages and disadvantages XML query and SQL query for SharePoint report.when we have large data which one has best performance? which one is faster?
I have no experience using XML query to create reports but a little using SQL query. So, from my unknowledge, I think the latter will be more effective and will have a better performance because of, in the end, XML queries would have to be translated into SQL queries in order to work, right? I suppose that SQL language is the basic and primary language SSRS will understand so, everything that will be made on top of SSRS will be translated to SQL.