AnsweredAssumed Answered

Queries about PI-ODBC

Question asked by sharon.meng on Sep 6, 2019
Latest reply on Sep 6, 2019 by jyi

Hello, my predecessors

 

      I am a beginner of pi. Now I use ODBC to query pi.

 

       I found that if I used select * from pipoint where time >='2019-09-01'and time <='2019-09-05',

 

       it would execute a long time later and report an error of 504 GateWay Time-out.

 

      But if I changed to select * from pipoint where time >='2019-09-01' and tag='xxx',

 

       the data would be queried. So I was wondering if my SQL query for the time-range query was wrong, or if the query for PI itself relied on tag.

Outcomes