Thingworx 9.2 Collection widget performance issues
I have been using the collection since it's initial release in I believe 8.2. Prior to that I used the repeater widget.
There are ALOT of possibilities you can do with the collection widget but the performance has always been a big issue and in 9.2 it seems like it may have gotten worse.
Full disclosure, I realize maybe I am not using it as intended, but I can't find much on best practices and such to tell me otherwise.
So, my current situation is as follows:
- I have a mashup that uses a collection widget to create an input screen.
- The collection widget is populated by a service that creates an infotable that will return at most 31 rows. Each row represents a day in a month. I loop through each day to return the results for that day if it exists, if not the values are empty.
- When I execute the service in composer the results come back in < 2 seconds
- I originally had the load behavior on the collection widget as load/unload. Which still wasn't exactly fast but I noticed all rows weren't saving since everything wasn't within view. So, it unloaded, makes sense. So I switched it to Load All and now, it takes >30 seconds to load which makes the page unusable.
- There is one thing that runs on each individual row mashup,
- insert/update service
- triggered by a session parameter changing (main mashup where infotable is returned sets this value. There is a save button on the main mashup that triggers an expression that spits out a random value, stores in the above mentioned session parameter)
- There are numeric entries that are populated by the mashup parameters from the infotable.
- insert/update service
Does anyone have any thoughts about what I could do to fix this?

