Caching?

Hello. I have a question as to best method to handle the following scenario.

I have an application that uses restrictionset (a set of decisions that determines what to include/not include) to query some data from a database and load into another database. The problem is while User A is loading this data which may take a while, user B can go and change the decisions in the restriction set and save it. So, in the middle of user A's load, all the changes that user B made appeared.

I would like to somehow cache user A's restriction set at the beginning of the load so that if user B goes and make changes to the same restrictionset, it doesn't effect the user A's load. Any idea what is the best way to implement this?

Thanks!

[758 byte] By [sdnida] at [2007-10-1 20:05:53]