Improve load performance of shared cck fields
gordon - May 6, 2008 - 14:21
| Project: | Content Construction Kit (CCK) |
| Version: | 5.x-1.x-dev |
| Component: | content.module |
| Category: | feature request |
| Priority: | normal |
| Assigned: | gordon |
| Status: | patch (code needs review) |
Description
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.
| Attachment | Size |
|---|---|
| cck-join.patch | 2.94 KB |
#1
interesting! Will give it a review.
#2
An updated patch to allow it to be applied again.
#3
add patch
#4
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.
#5
Updated patch