queries like 

DELETE FROM taxonomy_index 
WHERE  (nid = '100006035')

are unindexed and get very slow with a large table.

CommentFileSizeAuthor
#6 taxonomy-index-nid-index-2.patch835 bytesmarcvangend
#1 taxonomy-index-nid-index.patch599 bytesmarcvangend
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
CreditAttribution: marcvangend commented
Status: Active » Needs review
FileSize
taxonomy-index-nid-index.patch599 bytes

So we need this?

catch’s picture

catch
he/him
Primary language English
CreditAttribution: catch commented
Status: Needs review » Reviewed & tested by the community

Yep.

Dries’s picture

Dries CreditAttribution: Dries commented
Status: Reviewed & tested by the community » Needs work

No upgrade path?

moshe weitzman’s picture

moshe weitzman CreditAttribution: moshe weitzman commented
Status: Needs work » Fixed

This is a new table in D7. No HEAD => HEAD update path by convention. Please reopen if I have this wrong.

moshe weitzman’s picture

moshe weitzman CreditAttribution: moshe weitzman commented
Status: Fixed » Reviewed & tested by the community

woops. wrong status.

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
CreditAttribution: marcvangend commented
FileSize
taxonomy-index-nid-index-2.patch835 bytes

No, Dries is right. There is no upgrade path between HEAD versions, but the upgrade path from D6 must include this change as well.

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
CreditAttribution: marcvangend commented
Status: Reviewed & tested by the community » Needs review

needs testing.

moshe weitzman’s picture

moshe weitzman CreditAttribution: moshe weitzman commented
Status: Needs review » Reviewed & tested by the community

Ah, OK. thanks for clarifying.

Dries’s picture

Dries CreditAttribution: Dries commented
Status: Reviewed & tested by the community » Fixed

Committed to CVS HEAD.

Status: Fixed » Closed (fixed)

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