How to flush IIS

I am working on a site running on IIS and accessing a SQL-server database.
Through a windows admin application, I can configure some of the captions and fields on the site (these parameters/captions are stored in the SQL-server database).

My problem is that I have to restart the web-server to make the changes appear on the site. How can I flush the memory of the web-server? To stop and start the site on IIS, does not help.

Hope someone out there can help me..

Thanx, Pulp

It sounds like these setting might be stored in Application object variables. If so, then try unloading the application by going to the properties of the website (listed in the MMC) and then to the Home Directory tab and then clicking the unload button (if it's available). Then i would suggest moving the storage of these values into something a little more "dynamic". To hit the db for each page is the option that would guarantee the freshest data, but there is a performance issue, if you thousands of hits a day (and depending on the power of the servers). If this is not an option, try putting them into Session variable objects. The performance issue here changes from a db hit thing into a scalable thing. The use of Session objects makes it hard to scale the web app to multiple servers effectively. Although, in this case, since the information you'd be storing isn't user specific it's not as much an issue, but it still raises the memory on the web server.

hope this helps,

john

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

Excellent!!
That did the trick.

Thanks heaps!
Pulp