2 Replies Latest reply on Jan 17, 2018 1:28 PM by brunoz RSS
    brunoz Newbie

    Master Data Management of a SQL database

    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?