Order data by score about socialnetwork HOT 7 CLOSED

coool :) i hope I got time tomorrow and have a look at it :) I was working till 5 minutes ago :)

from socialnetwork.

I'm not sure if it's over complex.

I think this article helps to understand that the problem is only really complex using the classic SQL RDBMs .
http://www.cray.com/blog/graph-databases-101/
he really nails the usecase for graph databases and as you will read networks are a specific target.

Then read this :) as an easy kickstarter for a timeline idea :)
http://www.sitepoint.com/efficient-user-timelines-php-application-neo4j/

If you don't like it at least I hope you had a good read meanwhile :)

from socialnetwork.

I think about a view that stores the score and btree indexes in that view for faster ordering. So the normal post inserts wont be affected.

this is just top of my head I would need to spend time looking at the model an experiment with it.

from socialnetwork.

my final query looks like this
SELECT *, count(Score.id) as score, Content.id AS id, User.id as user_id FROM Content INNER JOIN User on Content.user_id=User.id LEFT JOIN Score on Content.id=Score.content_id WHERE Content.id < 1000000000 group by Content.id order by DATE(from_unixtime(Content.date)) desc, score desc, Content.id desc

I will upload the soloution to demo and make some performance benchmark tests.

from socialnetwork.

i'm curious to see some performance benchmarks view vs left join, vs own column...

from socialnetwork.

mhm some user reported this feature as a bug, because the were confused by the new ordering ....

e9142c8

from socialnetwork.

Ordering by score can be interesting for sure, but maybe it makes more sense to order
by activity/popularity. comments, likes, views etc.
So we may end up with a tracking system, which can be useful for understanding the user habits.

❤️ how i make every task overcomplex and nearly impossible to solve.

from socialnetwork.