0

I have an external list which is generated from an external content type pointing towards my WCF service. I want to expose this list to my users but I don't want to spam the WCF service every time a page is refreshed by a user. Essentially I want to be hitting the service every 15 minutes, caching the results in the external list and only updating the cache when the time limit expires.

I thought about a couple of possible solutions but each one hit a dead end, mainly because I'm not experienced with sharepoint possibilities at the moment:

  • A timed job which runs a workflow to copy the external list to another list every 15 minutes. Expose the other list to the users.
  • Implement server side caching on the external list (I didn't find anything which indicated this was possible)

Anyone care to chip in with a plausible solution that I can investigate?

Improve this question

1 Answer 1

Reset to default
-1

Or you can even write a powershell script to Copy List Items and run this through Windows task scheduler.

Improve this answer
1
  • Can you please extend this answer to make it more helpful, e.g. how to write a PowerShell script and make it run through the scheduler?
    – Robert Lindgren
    Commented Dec 9, 2013 at 9:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.