Hi, we currently are running DotNetNuke 04.09.01 on a webfarm, and we've been running the ClearCache job every 15 minutes through the DNN scheduler, but it seems to be causing hug performance issues. This may be because of the webwarm, and how the job to run the cahce would spawn on all portals, and all servers.

In particular, we've noticed how the SP GetModules runs every time this ClearCache job runs, and it seems to loop through all portals, taking roughly between 5-8 seconds to run through.

What does this SP do during the clearcache job, and it there any way to tune its performance?

We were thinking of calling the clearcache .aspx pages separately, and not use the DNN scheduler, using then link below as a base, making sure we hit each server and portal instance on the webfarm (Would the link below do the same think as the DNN Scheduler clearcache job?)

The benefit to doing things this way is we stagger the clearcache attempts versus the DNN scheduler potentially running many at the same time. When they all run at the same time, we've seen tons of waits in the database on that GetModules SP.

http://servername.searshc.com:port#/portalname/ClearPortalCache.aspx  

We did an experiment and turned off the DNN Scheduler ClearCache job just to see if the GetModules SP would go away, and if performance was better, and it was by alot. Now, we are trying to add back in the clearcache job, but are still wary about performance, and it seems the GetModules SP just crawls.

Any information on that SP, and the clearcache process, and how to improve would be appreciated!

Thx. Todd