This patch is a continuation of http://drupal.org/node/246084 which cleans up the loading of cck nodes to decrease the number of selects.

This patch improves the performance of shared single value fields by loading all the columns in a single select instead of one for each table.

As there are limits to the number of joins, I have limited this to blocks of 30 shared fields, and then it will do another select.

This should make the hit on shared fields a lot less, while still giving the benefits in views.

CommentFileSizeAuthor
#5 cck-join.patch5.89 KBgordon
#4 cck-join.patch3.03 KBgordon
#3 cck-join.patch2.94 KBgordon
cck-join.patch2.94 KBgordon

Comments

neclimdul’s picture

neclimdul
He/Him
commented
Title: Inprove load performance of shared cck fields » Improve load performance of shared cck fields

interesting! Will give it a review.

gordon’s picture

gordon commented

An updated patch to allow it to be applied again.

gordon’s picture

gordon commented
StatusFileSize
new cck-join.patch2.94 KB

add patch

gordon’s picture

gordon commented
StatusFileSize
new cck-join.patch3.03 KB

fix up bug with joining multiple fields that are on the same table. This happens when the content_field_xxx is not the table of the first field.

gordon’s picture

gordon commented
StatusFileSize
new cck-join.patch5.89 KB

Updated patch

karens’s picture

karens commented

Too old now, way past the time when we will add features to D5 version. This got fixed in D6 views.

karens’s picture

karens commented
Status: Needs review » Closed (won't fix)