cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

this query executing for longer time. Any idea on simplifying this query?

AP_10343008
15-Moonstone

this query executing for longer time. Any idea on simplifying this query?

While fetching data from sql db in thingworx , this query executing for morethan 80 seconds. Any idea on simplifying this query?

 

Query:

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

FROM ENGINEERING a 

WHERE a.MODEL like 'R24R%' 

AND a.cmp not in ( 

select cmp 

from ENGINEERING

where MODEL like 'R23R%' ) ;

ACCEPTED SOLUTION

Accepted Solutions
Velkumar
19-Tanzanite
(To:AP_10343008)

Hi @AP_10343008 

 

If you are going to display data in Mashup query only specific rows of data (using Limit Offset in Postgresql) and add pagination to Mashup.

 

Based on the Pagination number you can query the next set of rows from DB. This way you can decrease query time

 

More about Pagination Widget -  Pagination Widget (Themable) (ptc.com)

 

/VR

View solution in original post

3 REPLIES 3
Velkumar
19-Tanzanite
(To:AP_10343008)

Hi @AP_10343008 

 

Could you please explain your use case?

 

Where exactly this query is used whether in Mashup or in business logic service 

 

/VR

AP_10343008
15-Moonstone
(To:Velkumar)

It is used in database connector thing to show output in mashup.

Velkumar
19-Tanzanite
(To:AP_10343008)

Hi @AP_10343008 

 

If you are going to display data in Mashup query only specific rows of data (using Limit Offset in Postgresql) and add pagination to Mashup.

 

Based on the Pagination number you can query the next set of rows from DB. This way you can decrease query time

 

More about Pagination Widget -  Pagination Widget (Themable) (ptc.com)

 

/VR

Announcements


Top Tags