Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to speed up loading data via the SDK.

1 reply [Last post]
Adrian Archer
User offline. Last seen 12 years 37 weeks ago. Offline
Joined: 26 Nov 2002
Posts: 10

Greetings,

I'd like to ask if anyone could suggest a way to speed up the time required for the SDK to load the selected projects' data, especially from the TASKS table. If someone knows of a way to restrict the fields that the SDK loads to just the dozen or so fields that I need in Access, then that would be great.

I'm running P6.7 and Access 2010 with Windows 7.

 

Many thanks for any advice,

Adrian.

Replies

Andy Power
User offline. Last seen 3 years 27 weeks ago. Offline
Joined: 30 Aug 2006
Posts: 43
Groups: None

The number of fields which the SDK returns and updates depends on the SQL query which is embedded in VB code (on the Primavera Excel utilities) .... if you have knowledge of SQL I would imagine that you could quite easily change the code to match your specification and with any luck speed up the process.