I currently need to use ClearWorkspaceCache in a Python script tool so that it disconnects properly from ArcSDE. I am using the script tool in conjunction with the multiprocessing module and processes running the tool won't join properly, otherwise.
Does ClearWorkspaceCache work similarly in models? Would you need to apply it just the same as in a script tool? Also, if a model contains tools that call ClearWorkspaceCache, would that also apply to the rest of the model or just within the scope of the tool that cleared it?
I haven't found much documentation on what the cache is exactly and how it behaves. I'm also unclear on what Python objects and Model Builder objects can keep the database connection open.