Getting Counts of Items w/o Loading all Things

david17 · 2020-07-29T18:45:02.036Z

In order to reduce the amount of data required on page load, I’m converting my tables to fixed cell counts and allowing a user to move page by page (or jump to a page). This way, I don’t need to go fetch all of my data at once. Some lists may have tens of thousands of records.

In these tables, I’ve found it helpful to know where you are within the list and how many items are in the list.

I can use the Do a Search for:count method, but I think that will first need to load all of them. Do you know if there is a method (maybe I need to use the app’s API, or I can save the data as a field [although there are potentially many variation]) that will allow me to count the number of records without getting all of them?

Thanks!

ed727 · 2020-07-30T01:01:17.445Z

I recall reading in one of the performance threads, one of the founders saying that if :count is immediately after do a search for, then it’s run server side. But if you have do a search for, then a filter or something executed client side, then :count, then yes it would need to load all the items to count. But try it out…

Re: APIs I don’t know.

PS: if you want to reduce data on page load, why don’t you just set up the RG as scroll so it only loads a few items at a time?

ed727 · 2020-07-30T01:12:39.985Z

Here it is…

Performance Q&A guide Tips

So some overall guidelines. Note that these kinds of guidelines definitely have a sell-by date, since we’re always trying to optimize slow stuff, but here are some of the big performance levers: The more data a search fetches, the longer it takes. That probably sounds pretty basic, but we routinely see pages that fetch thousands of data items on page load. Or, we sometimes see searches that only fetch a few things – but each thing has KBs or MBs of text data stored in its field. Bubble …