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 <jeremie.bousquet(a)gmail.com>
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 <ludovic(a)xwiki.com>
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 <jeremie.bousquet(a)gmail.com>
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-tp6961805p69…
Sent from
the XWiki- Users mailing list archive at
Nabble.com.
_______________________________________________
users mailing list
users(a)xwiki.org
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users