I have a view with embedded anoter view that execute this 20 times:

SELECT node.vid AS _vid, node_data_field_session_time.delta as _delta, node.nid AS _nid, node_data_field_session_time.field_session_time_value AS value, node_data_field_session_time.field_session_time_value2 AS value2, node_data_field_session_time.field_session_time_rrule AS rrule FROM content_field_session_time node_data_field_session_time LEFT JOIN node node ON node.vid = node_data_field_session_time.vid WHERE node.vid IN (63,64) AND 1 ORDER BY node.nid ASC, node_data_field_session_time.delta ASC

this query takes 15ms. The date repeat is weekly for two years. It was even slower when I had it for 5 years.

turning on view cache would avoid the query but I can't because the view reports user signup status and I need show up-to-date information. Is there any solution to speed this up?

Comments

arlinsandbulte’s picture

arlinsandbulte commented
Status: Active » Closed (won't fix)

Hi,
I am just indiscriminately closing all support requests with no activity for more than 1 year.
If you consider this to still be a valid issue / support request, feel free to re-open.
BUT,
if you are re-opening this issue, please provide specific details on how this issue can move forward.

Thanks.