Skip to main content
N
NH_shree14-Alexandrite
14-Alexandrite
August 23, 2023
Solved

How to reduce the delay of mashup loading in Thingworx (9.3.0)?

  • August 23, 2023
  • 1 reply
  • 4226 views

Hello,

 

I have created a mashup which consists of 4 different mashups in it , which is mapped to fetch the data from the database and to display it on the mashup. (my mashup link is something like this https://<xyzname>-dev-twx.es.thingworx.com/Thingworx/Mashup/<mashup_name>

 

As i have also had auto refresh function to the services with 5 seconds refresh interval, the thing is mashup services are getting the real time data but in the mashup we are not able to any data even though the delay is been given to 5 seconds as we have the data  in each second in the database , In mashup we are seeing only refresh loading symbols on the widgets instead of data where the loading symbol will not be removed .

 

How to get rid of the loading symbol from the mashup and make the fetched data visible (also can i keep the auto refresh to 1 seconds as our machine data will be keep on updating for each second , is that the reason why I am unable to see the data)  and also how to get the mashup loaded fast (can we implement any cdn to the mashup.

 

Kindly help me to get the solution to this issue as soon as possible.!

 

Please refer the below image where you can get the brief idea about what I am trying to convey

NH_shree_0-1692763166216.png          NH_shree_1-1692763186266.png

 

NH_shree_2-1692763219892.png    

NH_shree_3-1692763348639.png

 

 

Regards,

Shree

Best answer by Velkumar

Hi @NH_shree 

 

No it wont affect anything. 

To debug your mashup, Create a New test mashup and bind value to widget. Don’t call any other service in that mashup and check whether data is loading properly

 

/VR

1 reply

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 23, 2023

Hi @NH_shree 

 

You can disable the loading icon in widget property

 

Velkumar_0-1692764351759.png

 

To improve loading time, could you please tell me how exactly you are fetching data from Database (maybe some sample query)

 

/VR

 

N
NH_shree14-AlexandriteAuthor
14-Alexandrite
August 23, 2023

Hi @Velkumar ,

NH_shree_1-1692766371507.png

for the above image the query is as follows 

NH_shree_0-1692766287099.png 

NH_shree_2-1692766484571.png   

NH_shree_3-1692766493712.png  

NH_shree_4-1692766501933.png

 

 

 

the query is  written like this ( sample for here i have used 3 parameters related to the above image)

SELECT  Extruder_0_Filament_Run_Out,Extruder_1_Filament_Run_Out

FROM SFv2printer

WHERE created_at=(select max(created_at) from SFv2printer);

 

Regards,

Shree

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 23, 2023

@NH_shree  Have you checked in the browser developer tool how many times the service is being called and the time taken to execute it?

Terms & ConditionsCookie settingsAccessibility statement