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

[NH_shree]

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

          

    

Regards,

Shree

[Velkumar]

Hi @NH_shree 

You can disable the loading icon in widget property

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

/VR

[NH_shree]

Hi @Velkumar ,

for the above image the query is as follows 

 

   

  

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

[Velkumar]

@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?

[NH_shree]

Hi @Velkumar ,

How to check? can you tell me 

Regards,

Shree

[Velkumar]

Hi @NH_shree  

1. Open your mashup in runtime

2. Press the F12 button and select Network

3. In the network you can see service calls and the time taken to load

/VR

[NH_shree]

Hi,

Also if i try to access my mashup page it is showing me the error like below 

Previously it was working fine but now a days it is showing like this and on the mashup the data is also not updating

Regards,

Shree

[NH_shree]

Hi @Velkumar ,

I am getting like this in the browser 

Row 1903 is the last data it should show but i am waiting , still it is showing like this and previously atleast it was showing last data logged even though the data loading symbol overlaps it but now when i am checking it from yesterday it is showing me 0 value, what could be done.

Regards, 

Shree

[NH_shree]

Hi,

The services are getting the status response 200 sometimes ,

again it is showing failed status 

 

[Velkumar]

Hi @NH_shree 

Could you please check what is the error message for failed calls? 

Click on call and Response should give error message

/VR

[NH_shree]

Hi @Velkumar ,

It is showing like this

Regards,

Shree

[NH_shree]

Hi,

If we uncheck theshow data loading property will it affect the auto -refresh of the service which is executing and mapped to widget to fetch and display the data from the database.

Regards,

Shree

[Velkumar · Accepted solution]

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