We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

newsfeed optimization? - Newsfeed | Forum

Joseph
Joseph Sep 8 '12
when will this take place my dashboard and user pages load so slow because the query for newsfeed runs for 9 seconds or longer at times
Den Team
Den Sep 10 '12
How many user do you have at all and online? 
ron sen
ron sen Jun 20 '14
Hey, here is the same issue.
We do have actually about 2.000 user registered and there are about 10 user online. The newsfeed is the main page.
We know that neck of a bottle is the sql query in
 ow_plugins/newsfeed/bol/action_dao.php
It is an awesome plugin and we want to use it in the future too.

My question is, how can I improve that? It's a little bit hard to get through all the program logic without documentation and without comments.

Do you have any ideas?

btw. we're using the 7071 build

Thank you very much for your efforts and sorry for my bad English :)
ron sen
ron sen Jun 26 '14
Hey again,


I got more precice stats from our community:


- We have over 2150 user.

- User online:

- - daily about 150 and

- - about 22 simultaneously.

- It takes about 27 seconds for page loading. That's too much^^

Is there an expert who could optimize the sql queries?
Or would it be better to change the table structure? Maybe it is okay that there is more redundant data but the load of necessary data will be faster?

I'm not a sql guru btw. ^^

I'm very grateful for any help =)

Oxwall Software
Oxwall Software Jun 26 '14
Unfortunately we do not provide such instructions. By the way what kind of hosting do you use?
You do not have permission to reply this topic