You probably should script deleting the feed documents. Otherwise you'll only remove part of it. You might have added data to additional tables and missing indexes show the problem. Using the Admin.Tools indexes in addition to the default ones my help. Ludovic 2011/11/7 Jeremie BOUSQUET <[email protected]>
I created the missing indexes for Reader as indicated, but no real change. I also noticed that though there are only 148 feed entries total, there are 4500 rows about "Reader" space in the activitystream_events table ! Seems that the "home page" of a feed "source" is updated and a major version is set each time feeds are consumed - in my case, after 1 week or so of usage, these pages are up to version 1433.1 ... As I have 3 feeds sources, it explains the 4500 or such rows in activitystream_events. I wonder if this is expected behaviour or an issue ? For these reasons I prefer to stop my experiments about the new Reader extension for a little while ... And I will drop rows related to feeds from db to see if it changes something about performances.
2011/11/7 Ludovic Dubost <[email protected]>
You might be missing indexes for the reader table, which could cause your issues. You'll find information about XWiki Feed Plugin indexes here:
http://extensions.xwiki.org/xwiki/bin/view/Extension/XWikiWatchSpeedup
Ludovic
2011/11/7 jerem <[email protected]>
I had the same issue (very slow activity stream), and last week-end it suddenly became horribly slow (few minutes for the home page). I added missing index, checked it was ok (request indicated from 2s to 0s), increased the document store cache to 2000, but it's still horribly slow. There are about 10000 rows in table activitystream_events (activitystream_events_params is empty), including 4500 just for the Reader application ! (with 3 rss feeds registered, each of them having the same count of rows wich seems a bit strange).
What is strange about it is that for home page for example, the page takes minutes to show up, and the activity stream displayed at the end is almost empty : only new items are shown, as if it had "forgotten" all the past history, though activitystream table is far from empty... I really think something went bad about the activity streams ... Also, individual requests to activitystream_events table seem to be quite fast, but requests occur maybe only one per second, making the whole thing very slow.
-- View this message in context:
http://xwiki.475771.n2.nabble.com/Activity-performance-is-slow-tp6961805p696...
Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost