super-table icon indicating copy to clipboard operation
super-table copied to clipboard

Super Table within Matrix field triggers large number of jobs to update search index

Open baileydoestech opened this issue 2 years ago • 1 comments

Describe the bug

We have a super table nested inside a matrix block as below:

image

When an entry containing this field is saved (any change, not just to the field in question) we see a large number of jobs triggered to Update search indexes and prune extra revisions. None of the fields have 'Use the field's values as search keywords' enabled.

image

This seems orders of magnitude larger compared to saving without the field, the jobs can sometimes just hang and do place quite a burden on the CPU/Memory of our site despite the change not usual touching this field. If this is expected then is there a way to disable it?

We have tried resaving the super table fields without any luck

Steps to reproduce

  1. Create a matrix block with a nested Super Table Field
  2. Populate the field for a given entry
  3. Save the entry without making any changes to the matrix block
  4. See a large number of jobs triggered

Craft CMS version

4.5.2

Plugin version

3.0.9

Multi-site?

Yes

Additional context

No response

baileydoestech avatar Sep 07 '23 09:09 baileydoestech

Looks similar to this request: https://github.com/verbb/super-table/issues/525

baileydoestech avatar Sep 22 '23 07:09 baileydoestech

Hello @baileydoestech - I've had the same exact issue - did you find a way get those large numbers of jobs to stop bogging down the cms?

There is an async tool that might be helpful to you that partly solves things… Im trying to find a way to not even need that in the first place though.

919Studios avatar Jun 03 '24 17:06 919Studios

I believe this got noticeably better for us in a recent Craft release but as super table is now deprecated we aren't going to spend much more time on looking into this. Async queue also helped with us

baileydoestech avatar Jun 03 '24 18:06 baileydoestech

Just read the verbb news article… glad pixel and tonic added native way to do this now 👍🏻 Time to get movin' with Craft 5 😄

919Studios avatar Jun 04 '24 01:06 919Studios