Massive insert attempt, after rebuilding sitestudio components (or a huge amount of nodes)

Created on 2 April 2024, 3 months ago
Updated 5 April 2024, 3 months ago

Problem/Motivation

In our company, we have a site with a huge amount of nodes that are using sitestudio components.
Once we import and rebuild the components, purge module is triggered and tries to massive insert data into purge_queue table.

Steps to reproduce

Rebuild a massive amount of nodes with sitestudio (in my case, by a sitestudio:package:import command). Purge module will try to insert lots of data into a single INSERT statement.

Proposed resolution

Refactor createItemMultiple() method and split it to avoid a huge amount of data to be inserted.
Check for the attached patch file

Remaining tasks

User interface changes

API changes

Data model changes

πŸ› Bug report
Status

Active

Version

3.5

Component

Code

Created by

πŸ‡§πŸ‡·Brazil daniel_arend

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.69.0 2024