Asle Frantzen

AF speeds up time - again

Blog Post created by Asle Frantzen Champion on Mar 31, 2011

Wow! My first blog post as an OSIsoft vCampus All-Star. Only six months after the vCampus Live! event of 2010!


I've been planning on writing this blog post ever since I got home from San Francisco last september, been extremely busy with interesting projects during the winter, and finally found some time for it today.












At vCampus Live! 2010 I presented the PI Asset Framework (AF) Speeds Up Time to Solution together with Stephen Kwan. If you didn't attend, you can watch it or download the original presentation at this link. The presentation shows my different efforts on finding the best way to import a hierarchical data structure from a lifecycle asset information management system called COMOS, and I tested the performance of these three options:



  1. Importing the data using the AFBuilder plugin for Excel
  2. Using the AFImport command line tool, (the same as importing through PI System Explorer)
  3. Using the AF SDK through Microsoft Visual Studio

I ended up using the second option - to import the data through the AFImport command line tool, as this turned out to be the most efficient way for me. As you can see in the presentation - or in the image to the right - I ended up with an average performance of appr. 500-700 elements per minute. My most efficient run included 133 430 elements based on a single Element Template, imported in 2 hours and 55 minutes - averaging at 762 elements per minute.


After my presentation I spoke with Chris Manhard, AF Development Lead at OSIsoft. He thought my performance seemed a bit lower than expected, and after I had returned home to Norway we did some investigations around my setup to see what would cause this. The result was I didn't have AF Server 2010 installed, and he explained they had made significant performance improvements with this release compared to the previous. I had been working on this project since early 2010, and the 2010 line of products - including the AF Server 2010 - wasn't released before August, about a month before the vCampus Live! event. So my results were all based on the AF version released in December 2009.






So, after installing AF Server 2010, here are the updated numbers:

  • 133 430 elements based on a single Element Template
  • Imported in 8 minutes and 45 seconds
  • Average speed of 15 250 elements per minute.

Now, that - ladies and gentlemen - is a 95% reduction in time!
Which truly means that "PI AF Speeds up time to solution"




I have added a new slide to the presentation, with the updated findings. Click here to download it!