Workload Spike from Data Fetching

Need help Database
1

Hi Everyone,

I have now made my app live but I am having some workload issues which are causing my workload to spike and go over capacity!

I believe it is due to the loading of my repeating group and everytime a user closes a pop up or enters the page again it loads a large quantity of data type “defect” with multiple field types.

I was wondering if anyone had a suggestion as to how I could optimize this workload??

image
image893×656 22.3 KB

Current setup:

I have a data type “defect” with 29 fields.

on my main page the user can see the list of defects they have in a repeating group. In this repeating group I only display a few types, eg. number, title, description, location, status.

The search is constrained by the project the defect is linked to and whatever the user inputs in the search/filter inputs.

image

When the user clicks on the group of a particular defect, a popup appears displaying a lot more information, including category, comments, files, date created, etc.

I may be wrong, but I suspect the issue is coming from when the user loads the page, although they can only see the “overview” of the defect, it is actually loading all of the fields of all of the defects they have created (which can be 100’s or even 1000’s!)?

Any assistance would be much appreciated with how I could go about, if my suspicion is correct maybe splitting the overview with the detailed view of the defect, or maybe it would be better if I set a fixed number of rows and created pages to maybe only display 20 at a time?

Thank you in advance!

2

Just an update after some additional deep diving:

From the log, I can in fact see that it is my “search for defects”

image
image848×346 15.8 KB

When I click onto this, it actually takes me to the search&autocorrect element (fuzzy search & autocomplete plugin)

image
image893×633 27.6 KB

image

To my knowledge, I believe this search doesn’t run unless you input text but I am now wondering if it is constantly running? If this is the case, would there be an effective way where I can limit this to user pressings search or confirming?

3

It will run any time that Search&Autocorrect element is visible.

Fuzzy search is awful for WU - it entails downloading all data (i.e ALL defects on your DB) to the browser and THEN filtering them.

Change your RG data source to Do a search for Defects with a contains/contains keyword(s) constraint coming from an Input’s value.

1 Like