I have project where I need to take a lot of labels for mashup from SQL.
First, there are configuration mashups to create questions and their config.
Then, there is mashup where customer chooses their setting, and radio buttons with questions depending on his are presented.
I use for this radio buttons, and connect labels with reading text from SQL querry. Unfortunatelly, it means ca hundred SQL calls to read every data for every label. It takes time, >20 secs.
And I'm looking for something more optimised, where I would call ONE SQL querry to read data, then split data from it to every label. Thought about storing whole SQL querry in some infotable inside properties of Thing, then services could read this data - but if two users will be working simultaneously, it can happen there will happen that infotable will be set with data for user A, then for user B, then both will use data of user B - so user A will have wrong datas.
