Goodtech

Max query size?

Discussion created by Goodtech on Dec 19, 2011
Latest reply on May 6, 2013 by hanyong

We have developed a C# application querying the PI archive for records. A query may look like the following:

 
SELECTtag, time, value, status, DIGSTRING(status) statusText
FROMpiarchive..picomp2
WHEREtag IN( '18DIP0291/Y/10SSAMP', '18DIQ0291/Y/10SSAMP', '18ZTR2221/Y/10SSAMP', '18ZTR4005/Y/10SSAMP', '18ZTR4221/Y/10SSAMP')
ANDtime> CAST('2011-11-07 18:30:00.0000000'asDateTime)
ANDtime<= CAST('2011-11-07 19:30:00.0000000'asDateTime)
ORDERBYtag, timeASC

Do you know if there is a max number of tags that can be queried in such a solution? We have discovered symptoms indicating that we do not receive values for all tag names. We are today querying about 3600 tagnames in one query. There are no exception from PI-Oledb recieved by our OleDB client.

Outcomes