Best way to update tasks data

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top