Increase performance when exporting many rows

Created on 23 April 2024, 2 months ago

Updated 13 June 2024, 20 days 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.

Comments & Activities

Open in Jenkins → Open on Drupal.org →
Core: 7.x + Environment: PHP 5.6 & MySQL 5.5
last update 2 months ago
Patch Failed to Apply
Issue created by @marco
Issue was unassigned.
Status changed to Closed: duplicate 20 days ago7:55am 13 June 2024
Comment 20 days ago →
🇬🇧United Kingdom james.williams
This patch builds on top of 🐛 Exception caused by MySQL 5.6 gtid replication Needs review ; it only applies once the latest patch there has been applied. I'm closing this ticket on the assumption that really this work should go into that ticket. Presumably it indicates the work in that other ticket needs improving on?

contrib.social Blog FAQ Discussions

Production build 0.69.0 2024