i wonder of this is technically possible.
We have 17000 sites. Some people might have workflows in some of these sites with tasks assigned to them.
Lets say a normal user can have up to 20 workflows with tasks associated to him self in some of those 17000 site collections.
I want to create maybe a webpart or an application page that shows the task where you need to do something.
This could be really expensive in terms of resources due to the number of sites we have. What would be the best approach, and can the results be cached? so that it doesnt execute the query if they press F5 each time, maybe refresh every 1hour or so.
Thanks