Ticket #5557 (closed enhancement: fixed)

Opened 4 years ago

Last modified 4 years ago

wxr importer: defer comment counts

Reported by: tellyworth Owned by: anonymous
Priority: normal Milestone: 2.5
Component: General Version:
Severity: normal Keywords: has-patch
Cc:

Description

Comment counts are calculated and recalculated every time a comment is inserted. That's inefficient when there are multiple comments per post.

The enclosed patch implements and uses a wp_defer_comment_counting() function. It's based on wp_defer_term_counting().

I also removed the comment_exists() check in the importer, since in practice it always returns false (the post_exists() check means we only attempt to import comments when the parent post is new, and hence has no comments).

Attachments

defer-comment-counts-r6528-2.patch Download (3.6 KB) - added by tellyworth 4 years ago.
defer-comment-counts-r6528-3.patch Download (3.7 KB) - added by tellyworth 4 years ago.
fix a poor assumption with comment_exists() change

Change History

  • Milestone changed from 2.5 to 2.4

fix a poor assumption with comment_exists() change

Lloyd pointed out the comment_exists() change made a poor assumption. It didn't support a common use case where a second import is run after a first pass to catch up on comments that were added during the transition period. The second patch fixes this: it does the comment_exists() check when the post already exists, and skips it when it does not.

comment:3   ryan4 years ago

  • Status changed from new to closed
  • Resolution set to fixed

(In [6532]) Defer comment counting. Props tellyworth. fixes #5557

Note: See TracTickets for help on using tickets.