gajendra_konnur

PI SQL Commander performance issue.

Discussion created by gajendra_konnur on Jul 5, 2012
Latest reply on Jul 17, 2012 by gajendra_konnur

Hi All,

 

I have configured one template having few attributes in PI AF .Some of the attributes are having ref to PI points while others have sql table.

 

I have created around 50,000 elements based on this template :

 

7563.afelemnt.jpg

 

I have then converted this template into TransposeArchieve and TransposeSnapshot Table using PI Sql commander. But its taking around 6-8 min to load data for TransposeSnapshot table as shown .While it was unable to load transpose archive table even after 20 min to ,so finally I canceled the execution of query.

 

Anybody have idea about the reason behind the problem and  to improve the performance of the same?

 

 2705.sqlcomnder.jpg

 

 

 

Thanks,

 

Gajendra Konnur

 

 

 

 

 

 

 

 

 

 

Outcomes