Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-06-27 : 02:13:10
|
| hi,my requirement is to update an xml file or enter a new record into it .The problem which i think i 'll be facing is , what happens if a thousand users try to write to the same xml file at a time from the web page.please reply,harshal |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-06-27 : 02:19:10
|
| you need to design your application so that doesn't happen.Let's back up a step. What is the file for ? What would trigger it's creation ? How often does it need to be updated ? How many users are likely to write to it ?Give some more info and I am sure we can come up with some good suggestions.Damian |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-06-27 : 02:30:48
|
| actually we want to make a scheduler which will remaind people about their schedules and if some one updates teh schedule the xml file is to be updated ,the mailing system will read the xml file and remaind the users of their tasks.the numebr of users my go to more than 1000.pl.replythnxs. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-06-27 : 02:41:22
|
| OKMakes sense. Well, the mail server doesn't need to read the XML file every second. So, maybe look at building the file from the database as a scheduled DTS job every minute.That way, the users are only hitting the database, which is quick. Then the file can get generated as a seperate process.Damian |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-06-27 : 02:51:40
|
| You mean to say that what ever changes are made in the schedule will be saved to the database and and some DTS job will genereate the file?would that effect the performance?and please tell me how to create an xml file or any other file with DTS job which can be read by my mailing system which most probabley will be an exe . |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-06-27 : 02:56:58
|
| The performance will be much better than generating it everytime the db changes.As for creating the XML in DTS, as well as reading it with your mailserver....that is waaaay beyond the scope of this site.I suggest you go to http://msdn.microsoft.com/ and learn about XML there. Heaps of good articles thereDamian |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-06-27 : 02:58:49
|
| thanxs a lot i think this approach is working.thnxs againharshal. |
|
|
|
|
|
|
editing or writing an xml file