Folks
Here is my project overview:
1.I have a set of SQL's stored within XML(call it as XML-SQL) and each XML is stored in the database with the unique ID.
2.I use mod_perl for this project and I cache all the xml during startup.
3.I also allow the users to create and store the sqls through a maintenance page.
4.My question is, what should I do to get the newly created XML-SQL to be available for the users, in other words how would I really refresh the cached sql's? Or is there any other way to do this.
Thanks for your help