Closed (duplicate)
Project:
Drupal Commons
Version:
7.x-3.0
Component:
Code
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Anonymous (not verified)
Created:
22 Jul 2013 at 09:19 UTC
Updated:
14 Feb 2021 at 15:49 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #1
Anonymous (not verified) commentedComment #2
Anonymous (not verified) commentedI researched this problem and found the query in commons_homepage_content view that have next query string:
SELECT node.changed AS node_changed, field_data_field_radioactivity.field_radioactivity_radioactivity_energy AS field_data_field_radioactivity_field_radioactivity_radioacti, node.nid AS nid
FROM
{node} node
LEFT JOIN {field_data_field_radioactivity} field_data_field_radioactivity ON node.nid = field_data_field_radioactivity.entity_id AND (field_data_field_radioactivity.entity_type = :views_join_condition_0 AND field_data_field_radioactivity.deleted = :views_join_condition_1)
WHERE (( (node.nid != :node_nid OR node.nid IS NULL) )AND(( (node.status = :db_condition_placeholder_2) AND (node.type NOT IN (:db_condition_placeholder_3)) )))
In conditions :node_nid I get value from Contextual filters that returns commons_follow_get_nids() for different types (node, group, user, term).
For my project function commons_follow_node_commons_follow_get_nids() returns around 14000 records and it all insert into view query, so I get the next structure of this query :

So, if I follow a lot of content I have never see it and/or crash site.
Is it ok?
Comment #3
ezra-g commentedThis appears to be a duplicate of #1863340: Refactor follow argument plugin to scale better .