I have created a linked data source of two lists:
- News categories (custom list)
Because there are no more than 5 news categories in the second list I am confident that my XSL won't have any problems in finding the News category associated with the Page efficiently. My page content type has a lookup property on the News category list, so this is what I'm filtering the News categories on.
However this has raised a query in my head. If I was to have multiple of these DFWPs on the same page doing very similar queries, or in the case of the News category list the exact same query, is there anything in SP that optimizes this? Is the XML of the list heavily cached to begin with so the query cost negligible?
In general some information on out of the box optimizations that may occur when doing CAML queries using SPDataSources would be great.