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:
Does anyone have any thoughts about what I could do to fix this?
There are some unanswered questions here:
If you're able to share your mashup, we'll be happy to take a look.
1) Yes, if there isn't any data for the month yet. It will still display for the day with numeric entry widgets to enter data.(See attached) No matter what day you select within a month, the same data will display and performance is the same. There is a service we created to return an infotable with each day in a month. That is used to return data from a database for each day if it is available.
2) See attached for the mashup.
3) Only 1 service call is made per cell. The service is the insert/update service for the database. On mashup load nothing runs. That service only runs when the "Save" button on the main mashup is pressed. When that button is pressed an expression is triggered on the main mashup that spits out a random numeric value. The output is bound to a session parameter. Each cell mashup has the sessionparameter changed event bound to trigger the insert/update service. The values displayed on load are passed in as mashup parameters from the infotable bound to the collection widget.
Thank you for the response, I hope this provides enough further details.