I'm implementing a full text search on list contents.
Is it more efficient to fire a SPSiteDataQuery on every request with a dynamically built CAML-Query, to filter the items?
Or is it better to fetch the data once, store it in e.g. HttpRuntime.Cache and filter the data somehow in code (maybe via DataTable.Select or something...didn't try this).
What do you think?