Server Resources for Creating/Modifying XML Files
-
A friend has recently consulted me regarding server resource concerns for an idea that he has come up with. Unfortunately I was not able to answer his question directly and so I decided to see what others in the community have to say. The Question:
"If we were to create a script that builds/modifies XML files on the server for every active user in our database; how much of a strain on the server's resources would occur?"
My initial reaction was to ask some questions regarding number of users and how often these files would be created/modified. The Answers:
- 10,000+ (and growing)
- The files would be edited/created each time a user edits/creates his/her profile. So that the data in the XML file is always up to date.
The data for the users is currently being stored in a SQL Server 2000 database and the site is hosted on a shared Windows 2003 Server running ASP.NET v. 1.1. I am not actually sure why he wants to do this or the strain that it will cause on the server with files constantly being opened and closed for editing in conjunction with database queries. Any advice or knowledge on the subject is greatly appreciated. Thanks, -Brian C.