"Content I posted in" is slow

[SecondSight]

Hello ! ?

I still have the "Content I posted in" item in my activity streams menu but it is slow : it takes about 13 seconds to show the results.

Here is the output in the mysql slow log :

# Time: 180507  5:00:10
# User@Host: mywebsite[mywebsite] @ localhost []  Id: 4591018
# Query_time: 13.367841  Lock_time: 0.000212 Rows_sent: 25  Rows_examined: 4515423
SET timestamp=1525662010;
/*IPS\Content\Search\Mysql\_Query::search:346*/ SELECT main.* FROM `ibf_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\forums\\Topic\\Post' OR index_class='IPS\\cms\\Pages\\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\links\\Link','IPS\\links\\Link\\Comment','IPS\\links\\Link\\Review') ) OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) ) AND ( ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) AND index_is_last_comment=1 ) OR ( index_class='IPS\\forums\\Topic\\Post' AND index_is_last_comment=1 ) OR ( index_class='IPS\\cms\\Pages\\PageItem' AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) AND ( index_container_class IN('IPS\\gallery\\Category') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\links\\Link','IPS\\links\\Link\\Comment','IPS\\links\\Link\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) AND index_is_last_comment=1 ) ) AND ( ( ( index_class IN('IPS\\forums\\Topic','IPS\\forums\\Topic\\Post') ) AND (( index_container_id=221 AND index_date_updated > 1458097994) OR ( index_container_id=14 AND index_date_updated > 1458097994) OR ( index_container_id=64 AND index_date_updated > 1458097994) OR ( index_container_id=21 AND index_date_updated > 1458097994) OR ( index_container_id=29 AND index_date_updated > 1458097994) OR ( index_container_id=137 AND index_date_updated > 1458097994) OR ( index_container_id=4 AND index_date_updated > 1458097994) OR ( index_container_id=216 AND index_date_updated > 1458097994) OR ( index_container_id=140 AND index_date_updated > 1458097994) OR ( index_container_id=43 AND index_date_updated > 1458097994) OR ( index_container_id=66 AND index_date_updated > 1458097994) OR ( index_container_id=152 AND index_date_updated > 1458097994) OR ( index_container_id=146 AND index_date_updated > 1458097994) OR ( index_container_id=9 AND index_date_updated > 1458097994) OR ( index_container_id=138 AND index_date_updated > 1458097994) OR ( index_container_id=173 AND index_date_updated > 1458097994) OR ( index_container_id=151 AND index_date_updated > 1458097994) OR ( index_container_id=19 AND index_date_updated > 1458097994) OR ( index_container_id=132 AND index_date_updated > 1458097994) OR ( index_container_id=15 AND index_date_updated > 1458097994) OR ( index_container_id=148 AND index_date_updated > 1458097994) OR ( index_container_id=143 AND index_date_updated > 1458097994) OR ( index_container_id=150 AND index_date_updated > 1458097994) OR ( index_container_id=202 AND index_date_updated > 1458097994) OR ( index_container_id=144 AND index_date_updated > 1458097994) OR ( index_container_id=174 AND index_date_updated > 1458097994) OR ( index_container_id=35 AND index_date_updated > 1458097994) OR ( index_container_id=159 AND index_date_updated > 1458097994) OR ( index_container_id=142 AND index_date_updated > 1458097994) OR ( index_container_id=41 AND index_date_updated > 1458097994) OR ( index_container_id=220 AND index_date_updated > 1458097994) OR ( index_container_id=223 AND index_date_updated > 1458097994) OR ( index_container_id=219 AND index_date_updated > 1458097994) OR ( index_container_id=149 AND index_date_updated > 1458097994) OR ( index_container_id=5 AND index_date_updated > 1458097994) OR ( index_container_id=44 AND index_date_updated > 1458097994) OR ( index_container_id=130 AND index_date_updated > 1458097994) OR ( index_container_id=139 AND index_date_updated > 1458097994) OR ( index_container_id=31 AND index_date_updated > 1458097994) OR ( index_container_id=158 AND index_date_updated > 1458097994) OR ( index_container_id=70 AND index_date_updated > 1458097994) OR ( index_container_id=46 AND index_date_updated > 1464529599) OR ( index_container_id=145 AND index_date_updated > 1458097994) OR ( index_container_id=176 AND index_date_updated > 1458097994) OR ( index_container_id=147 AND index_date_updated > 1458097994) OR ( index_container_id=135 AND index_date_updated > 1458097994) OR ( index_container_id=28 AND index_date_updated > 1458097994) OR ( index_container_id=215 AND index_date_updated > 1460905040) OR ( index_container_id=162 AND index_date_updated > 1458097994) OR ( index_container_id=213 AND index_date_updated > 1458097994) OR ( index_container_id=129 AND index_date_updated > 1458097994) OR ( index_container_id=187 AND index_date_updated > 1458097994) OR ( index_container_id=217 AND index_date_updated > 1458097994) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(221,14,64,21,29,137,4,216,140,43,66,152,146,9,138,173,151,19,132,15,148,143,150,202,144,174,35,159,142,41,220,223,219,149,5,44,130,139,31,158,70,46,145,176,147,135,28,215,162,213,129,187,217) ) )) AND ( index_item_id NOT IN (86812,90614,162202,166898,169393,207016,218227,239556,265966,286815,304207,307640,309413,309931,313878,316195,318155,318456,323927,324145,324562,324899,324936,325316,325387,325397,325412,325418,325581,325995,326065,326183,326595,326799,327227,327391,327554,327802,328035,328154,328199,328393,328415,328474,328952,329248,329400,329405,329667,329755,329767,330052,330106,330379,330597,330852,331016,331169,331171,331559,331610,331688,331692,332027,332110,332368,332481) ) ) OR ( ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) AND (( index_date_updated > 1458097994)) ) OR ( ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) AND (( index_date_updated > 1458097994)) ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND (( index_container_id=448 AND index_date_updated > 1458097994) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(448) ) )) ) OR ( ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) AND (( index_container_id=43 AND index_date_updated > 1458097994) OR ( index_container_id=12 AND index_date_updated > 1459385142) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(43,12) ) )) AND ( index_item_id NOT IN (3701,3702,3703,3704,3705,3706,3707,3708,3932,3933,3942,3943) ) ) OR ( ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) AND (( index_container_id=43 AND index_date_updated > 1458097994) OR ( index_container_id=12 AND index_date_updated > 1459385142) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(43,12) ) )) ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND (( index_date_updated > 1458097994)) ) OR ( ( index_class IN('IPS\\links\\Link','IPS\\links\\Link\\Comment','IPS\\links\\Link\\Review') ) AND (( index_container_id=65 AND index_date_updated > 1458097994) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(65) ) )) AND ( index_item_id NOT IN (1080) ) ) OR ( ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) AND (( index_date_updated > 1458097994)) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(9,index_permissions) OR FIND_IN_SET('m15282',index_permissions) OR FIND_IN_SET('ca',index_permissions) ) ) AND index_hidden=0 AND index_date_updated>1494125997 ORDER BY index_date_commented DESC LIMIT 0,25;

Do you have the same problem ?

Thank you. ?

[bfarber]

Some changes have been made for 4.3.2 to improve performance with some streams such as this one. We apologize for any inconvenience in the mean time.