Automatic 'Load More' action
Forgive me if this has already been discussed, but I feel that it is a fairly major issue. I am running into quite a few situations where I am running into the 'Apex heap size too large' error with some of my models; judging by some quick searching it looks like this is a fairly common issue. I know how to work around it by limiting the number of records that are returned by a single query, but I would like to hear from the Skuid developers about whether there are any better solutions for the problem (I know aggregate models can be a solution, but they have their own issues I'll address below). I have one model (Transactions, Quarter to Date) that is particularly problematic. Early in a quarter it works just fine, but of course as the days and weeks go by the number of transactions add up and all of the sudden I am left with a Heap Size error, which I can fix by limiting the query results on the model. But that causes a host of other problems-- all of the sudden my CEO wants to know why the chart on the model page isn't showing recent transactions, and I need to explain to him that he needs to go to a separate tab and hit the 'Load More' button a few times to get all of the data. That is less than ideal, to put it lightly. Would it be possible to do sequential and automated 'Load More' actions so that I don't have to explain to users that they need to keep hitting 'Load More' in order to get their graphs and charts to reflect what is actually in the database? If I'm clicking 'Load More' on my own, why can't Skuid just do it on its own a few times until the table/chart shows all of the available data? Can a snippet do this for me somehow? I have some really wonderful Skuid pages showing transactions, commissions, and other data for my users, but as the year progresses and the amount of YTD data piles up the pages are becoming increasingly difficult to manage. What solutions are the Skuid developers considering here? Instructing everyone to get in the habit of clicking 'Load More' every time they open a Skuid page is not a good solution, and this kind of data isn't easily aggregated either (and aggregations bring their own set of issues with them, such as very ugly chart series names when dealing with dates).