7 Nov
2011
7 Nov
'11
3 p.m.
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