Hello,

So I'm ingesting, will my site works faster if to unpublished some stream items with SQL query? For example I can unpublish some core items about friendship, following, user joined cluster, user joined site...

Regarding the above, I am afraid unpublishing these records from your stream table might not boots the query performance since those unpublished records still in the table and SQL still need to filter out these unpublished records.

If you want to optimise your stream table, your best bet is to archive your old stream items so that the your stream tables become small which eventually give better SQL performance. In my opinion, no one will be interested with the outdated story posts?

If archiving your stream table is not an option, then I suggest you to delete the story posts that you think is not important. Like the friendship, following, user joined cluster and etc. You may run below queries to delete these stream items.

-- following items



delete a, b 

from #__social_stream as a

inner join #__social_stream_item as b on a.id = b.uid

where a.context_type = 'followers'

and a.verb in ('follow');









-- adding friends



delete a, b 

from #__social_stream as a

inner join #__social_stream_item as b on a.id = b.uid

where a.context_type = 'friends'

and a.verb in ('add');





-- joined group



delete a, b 

from #__social_stream as a

inner join #__social_stream_item as b on a.id = b.uid

where a.context_type = 'groups'

and a.verb in ('join');









-- liked page



delete a, b 

from #__social_stream as a

inner join #__social_stream_item as b on a.id = b.uid

where a.context_type = 'pages'

and a.verb in ('like');







-- attending event



delete a, b 

from #__social_stream as a

inner join #__social_stream_item as b on a.id = b.uid

where a.context_type = 'guests'

and a.verb in ('going');

Please backup your database first before you run these SQL and remember to replace #__ to your Joomla table prefix.

Hope this help and have a nice day