Increase performance when exporting many rows

Created on 23 April 2024, 7 months ago
Updated 13 June 2024, 5 months ago

Problem/Motivation

When trying to export many rows (10000+), even using a batch, the first step may take several seconds.
In some environments this may result in a timeout.

Steps to reproduce

Try to export a view with a large number of items.

Proposed resolution

After some profiling, the issue at least in my case was the initial loading of the temporary table.
Changing this part to use multi inserts fixed the issue.

Remaining tasks

Testing.

User interface changes

None.

API changes

None.

Data model changes

None.

Feature request
Status

Closed: duplicate

Version

3.0

Component

Code

Created by

🇮🇹Italy marco

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

Comments & Activities

Production build 0.71.5 2024