Skip to main content
A
AP_1034300816-Pearl
16-Pearl
October 4, 2023
Solved

Any shortcut to get infotable length quickly

  • October 4, 2023
  • 2 replies
  • 1796 views

We fetched 5000 rows and 4 columns from sql db in 40seconds.

Then In Thingworx code, if i used InfoTable.length to find total number of rows in table is taking additional 20seconds. 
Any other shortcut to get table length quickly.?

Query:

SELECT distinct a.cmp , a.engseq , a.it,  null as totalrows

FROM ENGINEERING a 

WHERE a.MODEL like 'R24R%' 

AND a.cmp not in ( 

select cmp 

from ENGINEERING

where MODEL like 'R23R%' ) ;

 

 

Best answer by Velkumar

Hi @AP_10343008 

 

You can try 

 

 

infoTable.rows.size()

 

 

 but I'm not sure whether it will improve performance. Please do a comparison between the size and length

 

For 5 Rows of Data, Size() runs faster than the length method

 

Velkumar_0-1696410753119.png

 

 

Difference between Size() & length - https://www.geeksforgeeks.org/what-is-the-difference-between-array-size-and-array-length-in-javascript/

 

/VR

2 replies

V
19-Tanzanite
Velkumar19-TanzaniteAnswer
19-Tanzanite
October 4, 2023

Hi @AP_10343008 

 

You can try 

 

 

infoTable.rows.size()

 

 

 but I'm not sure whether it will improve performance. Please do a comparison between the size and length

 

For 5 Rows of Data, Size() runs faster than the length method

 

Velkumar_0-1696410753119.png

 

 

Difference between Size() & length - https://www.geeksforgeeks.org/what-is-the-difference-between-array-size-and-array-length-in-javascript/

 

/VR

V
VladimirRosu_11662719-Tanzanite
19-Tanzanite
October 4, 2023

I find it strange that infoTable.length would take additional 20 seconds, if run just once.

Can you share all the service code where you observed this situation?

A
AP_1034300816-PearlAuthor
16-Pearl
October 4, 2023
    let queryA = "sql query........";
    result = Things['SmartParts.DataBaseConnector-TH'].Query({
        inQuery: queryA
    }); 
 
  //if temp infotable used to calculate length, then it is taking some more time to give results. SO using same result infotable
    let count =result.rows.size();
    if(count>0) result[0].COUNT=count;
    else result[0].COUNT=0;
Terms & ConditionsAccessibility statement