Caching

Another way to improve the performance of your application is to cache as much as possible. For example, the list of projects for a typical schedule is small, and the project ItemId property can be easily cached and used when creating new tasks that are linked to a particular project. In this case, all the ProjectItemId property values can be read from the Projects table using a single call to the GetRows method.