M
MCB
OK, I have to make some updates to the Project Server database every time a
project is saved. One way to do is, write code on Project Save event handler.
This is what I am doing now. However, problem with this approach is, there
are many users of PWA and every user saves a project, the code is executed
and it makes the save process very slow.
I am looking for an alternative way to do the same. One way, I can think of
is, to have a Windows Service running on the server and Project Save event
will write some variable to a text or XML file and Windows Service will be
looking for this XML file on a certain interval of time and when the value is
TRUE, it will update the database.
Any better ideas?
project is saved. One way to do is, write code on Project Save event handler.
This is what I am doing now. However, problem with this approach is, there
are many users of PWA and every user saves a project, the code is executed
and it makes the save process very slow.
I am looking for an alternative way to do the same. One way, I can think of
is, to have a Windows Service running on the server and Project Save event
will write some variable to a text or XML file and Windows Service will be
looking for this XML file on a certain interval of time and when the value is
TRUE, it will update the database.
Any better ideas?