Workload usage on repeating group

Hello,

I’m contacting you to get your opinion, I’m using a lot of Workflow simply to display data on repeating groups. My simple display of my products consumes 9000 logs per day. I’m looking to display a certain type of product.

Does anyone know of a possible optimization or is this quite normal given that I’m filtering my data?

Thanks for your help


WU usage for retrieving data is calculated based on:

  • number of things returned (0.015WU per thing)
  • size of things returned (a little amount per character)
  • a fixed amount of 0.3 WU per search

So, no matter how you reduce the problem, your two options are to reduce those first two.

To reduce the number of things returned, consider:

  1. Only updating the search when a search button is clicked (as opposed to instantly when they change a filter). You can do this using Display list in a Repeating group. Put this in a custom event and Display list of Montres based on the filters. Whenever a filter’s value is changed, trigger that custom event.
  2. Make the cards larger so less are displayed at once (so actually make the user see less results)

To reduce the size of things returned, consider creating a satellite data type. This is kept in sync using a database trigger, but all it has on it, are the fields you want to use for search. Any heavy fields (like a long description) could be removed. I probably wouldn’t bother with this unless the data type is unusually heavy (with long lists of Things on it).

If this was my app, my first port of call would be to only update the search when a search button is clicked, so try that first.

As another note, I can see that you’re dynamically sorting using conditionals. I’d recommend exploring the ‘Change which field’ option in Sort by. You can dynamically specify the sort order. You need an option set e.g Date created (asc), Date created (desc), Rating (asc), Rating (desc). This means you don’t have to update the constraints in every expression when you add a new filter.

2 Likes