Repeating panel is slow to populate

[alcampopiano]

For those watching, Shaun and I continued outside this thread and he helped me to optimize the app so that the speed is acceptable. I cannot share a clone at this time but in his response you can get a sense of the techniques he used to speed things up. From what I understand, he removed unnecessary server calls by returning much of what I needed inside of a single server-side function. Part of this optimization required one of my smaller tables to be de-normalized.

@shaun

Ok, I’ve been tinkering and I’ve made it somewhat faster.

The multiple row link in the question table was a little troublesome because multi-row links aren’t currently cached, which is why the dict() was a good idea. However, this was still causing more lookups than necessary and since there is actually only one question per theme, I’ve changed it to have a single link theme->question.

The get_themes function now does a get for a question and a search for the themes that link to it. This takes up most of the page load time: 360ms when I tested it. 130ms of this is latency and the rest is handling the request on the server side and performing the queries.

I got rid of the other two requests entirely by de-normalising the colour data. There was one row in the colors table per question , so I’ve just added color , icon and text columns to the question table. The get_themes function returns the question row as well as the themes for that question, so after calling get_themes we already have the colour data and we don’t need to make any more round-trips.