Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
I am trying to maintain a SQL table with a mashup.
I realized that with a repeater function coupled with some services that call some sql scripts (update, select...)
This works just fine but is extremely slow. In fact i can not select more than 50 rows in my display if i do not want to degrade the performance too much,
I know for a fact that the SQL queries are extremely fast so the performance problem is not related to the execution of these. It may lie in the conversion of the SQL result in a thingworx datashape though?
1- am I using the wrong technology/way of designing my mashup?
2- i found it tough to find in the logs the elements that are actually slow, how can i do that?
Any idea/example of someone who did that in the past?
Thanks
Within the Composer you can go to Monitoring/System/Status which will show you memory usage of the JVM that might be impacting the performance.
thanks Pai. I will try that.