AlistairFrith

PIProperties.Add() is SLOW!!!

Discussion created by AlistairFrith on Feb 10, 2011
Latest reply on Feb 12, 2011 by andreas

Is there any way of speeding this up? We are trying to create an MDB hierarchy and we have the following function in our SDK class:

 
public PISDK.PIProperty NewProperty(PISDK.PIProperties properties,
                                    string name,
                                    object value)
{
   return properties.Add(name, value);
}

 
With our initial test data, we have around 3000 properties to create (the full app will have of the order of 50x as many) and it takes around 10 minutes. This means that the full data load of around 150k properies will take around 10 hours! Datalink seems to take a similar time. Both seem to be slowing down during the upload: DL does 1/3 of the test data in 2 minutes, 1/2 way through in 5 minutes and is still going after 9 minutes. An earlier test on another machine loaded a different 100 item MDB structure in 10 seconds!

 

The vast majority of time is spent within the function above. Is there any way of speeding up the creation of properties in the MDB?

 

Would I be better off asking OSI Support?

 

--- Alistair.
 

Outcomes