Hi, guys.

I need your help in the next problem:
Site content includes about 30 groups, 36600 nodes of question with 300 000 comments to them and about 30000 users. When I go to homepage on anonymous user it's alright, but when I loggin like admin or other user, I waiting for loading page around 5 minutes and then get a message like "Apache crashed."

Probably it's problem depend of views "What's going on?"
There are no any records with error in php_error_log.

So, can you help me by any ideas for fix this problem?

Thanks.

CommentFileSizeAuthor
#2 query_condition.jpg227.06 KBAnonymous (not verified)

Comments

Anonymous’s picture

Component: Code » Miscellaneous
Anonymous’s picture

Component: Miscellaneous » Code
Category: support » bug
StatusFileSize
new227.06 KB

I 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 :
Query conditions

So, if I follow a lot of content I have never see it and/or crash site.
Is it ok?

ezra-g’s picture

Status: Active » Closed (duplicate)