How to read time phased data from Project Server 2007 directly from Project Server Database ?
        Posted  
        
            by Nikhil Vaghela
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Nikhil Vaghela
        
        
        
        Published on 2010-04-19T06:57:12Z
        Indexed on 
            2010/04/19
            7:03 UTC
        
        
        Read the original article
        Hit count: 697
        
c#
I am working on a custom web part for Project Web Access, for Project Server 2007.
We are so far using PSI web services only to read and write data from and to Project Server 2007 databases.
But there is a signinficant performance issue when you retrieve time phased data through Statusing web service, it is basically an expensive call for querying time phased data for each tasks.
I want to access Time phased data entered by user for each tasks by directly hitting the Project Server Database. [ I do not want the solution suggested at this link : http://blogs.msdn.com/project_programmability/archive/2007/05/24/getting-at-the-task-time-phased-data.aspx as it reads data from reporting database which gets entry only after the project is published. ] I want to get time phased data as soon as user enters it.
Any idea ?
Thanks.
© Stack Overflow or respective owner