Or does the server have to do all the crunching, and then lop off the last 7 days only from the entire bunch as you mentioned in a similar scenario?
Maybe one for Mr Mongo himself?
Quote by gav
Trying to retro fit these kind of limits is always going to be hard *sigh*
Reducing the amount of activity displayed isn’t going to help. In order to show the most recent activity we need to aggregate the activity of ALL friends then slice the top records.
Perhaps 200 was a little optimistic Maybe a cap that would not affect any of our current users but would at least give an upper bounds and deterministic performance. I think 1000 is reasonable.
I bet there isn’t a social site out there that has unlimited friends. Facebook has 5,000 but they have 180k servers and thousands of programmers![]()
=== Not ALL LIVES MATTER until BLACK LIVES MATTER ===
Quote by gav
800 of you extreme socialites.
A different option could be to adopt the List function of twitter - allowing you to see the activity of a selection of people rather than the full list. You could then allow users to select what information they wanted on that list and who was on on it - you could limit that to as few as 20 friends and I don't think you'd get many complaints. The system could just mirror the current Story Follows utility.
Quote by PersonalAssistant
I think there should be a few new socialite badges and maybe revamp the socialite requirement (as it seems so many easily add and add and add and are a socialite within days) .....
for example ....
over 200 friends = Socialite
from 400 - 899 friends = Extreme Socialite
Over 900 friends = Ultra Socialite
Quote by overmykneenow
Out of interest, just have far have you jumped into NoSQL?
Quote by gav
Apart from the forum which still runs an RDBMS (Sql Server) we are fully NoSql (we have been for a few years now). It comes with its own challenges, but I think its been the right decision.
The RDBMS crew (MS SQL & Oracle) scale with cash, which we dont have.
Quote by PersonalAssistant
over 200 friends = Socialite
from 400 - 899 friends = Extreme Socialite
Over 900 friends = Ultra Socialite
You can’t truly call yourself peaceful unless you are capable of violence. If you’re not capable of violence, you’re not peaceful. You’re harmless.
Why not join my popular Lush Group One Tit Out Group | Lush Stories? For all those who enjoy pictures of women showing just one boob. Lots of cheeky flashes and accidental slips. Come on, you know you want to! Annie xxx
Quote by naughtyannie
Well, the 1000 limit when it came in hit me pretty hard. If I hadn't been turning down maybe 75% of my friend requests over the last 6 months or so, I'd have probably had twice that many... yeah, I know, way too many, but people just kept asking, and it was so hard to say no, especially when they said how much they liked my stories - what writer could possibly resist that sort of come-on?
Anyway, after some drastic and fairly random deleting, I got things down below the limit. But (on behalf of the many Anniemaniacs out there) - no more limits please!
You can’t truly call yourself peaceful unless you are capable of violence. If you’re not capable of violence, you’re not peaceful. You’re harmless.