When migrating large WordPress sites, including post_content and post_excerpt in the main query() result set can exhaust PHP memory limits, since all rows are loaded with their full text content at once.

This patch removes both columns from query() and fetches them individually per row in prepareRow() via a targeted SELECT, keeping memory usage bounded regardless of dataset size.

CommentFileSizeAuthor
#3 3588257-2.patch1.22 KBunstatu

Issue fork wordpress_migrate_sql-3588257

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

unstatu created an issue. See original summary.

unstatu opened merge request !8

unstatu’s picture

unstatu commented
Status: Active » Needs review
StatusFileSize
new 3588257-2.patch1.22 KB

Patch provided.

omarlopesino made their first commit to this issue’s fork.

omarlopesino’s picture

omarlopesino
he/him
commented
Category: Feature request » Bug report
Status: Needs review » Fixed

Nice catch. Merged and released in 1.0.1

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.