Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

Why limit post counts to 1000 w/o checking profile?.. DU discriminates?

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
This topic is archived.
Home » Discuss » Archives » General Discussion (1/22-2007 thru 12/14/2010) Donate to DU
 
DB1 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 03:59 PM
Original message
Why limit post counts to 1000 w/o checking profile?.. DU discriminates?
By putting the cutoff at 1000 don't we create a sub class of under 1000 posters? Just a thought why not post the members current post count number?
The reason I ask is I am here daily for a couple years with just a few hundred posts, some of which I could have done better, but others who have been here a far less period have 1000 plus promoting whatever 24/7. Maybe a membership sign on date and total post number next to ID would be better?
Printer Friendly | Permalink |  | Top
Make7 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:02 PM
Response to Original message
1. Fuck you, newbie. ( n/t )
:sarcasm: (just in case)
Printer Friendly | Permalink |  | Top
 
JNelson6563 Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:42 AM
Response to Reply #1
31. lol
DU ranks highly in smart-assery dept. One of the many reasons I come STILL come here. :toast:

Julie
Printer Friendly | Permalink |  | Top
 
ixion Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:05 PM
Response to Original message
2. bandwidth
it takes a great deal of memory to do count query after count query like that.
Printer Friendly | Permalink |  | Top
 
tachyon Donating Member (520 posts) Send PM | Profile | Ignore Thu Mar-13-08 04:10 PM
Response to Reply #2
4. More than a long integer? 4 bytes?
??
Printer Friendly | Permalink |  | Top
 
Hubert H. Hubert Donating Member (208 posts) Send PM | Profile | Ignore Thu Mar-13-08 08:03 PM
Response to Reply #4
21. 32 bits
At one post per second, nonstop 24/7, it would take 68 years to reach the limit of a 32 bit signed int (136 years for unsigned).

Just in case you were wondering.
Printer Friendly | Permalink |  | Top
 
ixion Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 09:29 PM
Response to Reply #4
22. to be more specific: database resources
you've got do to a query to obtain the number of posts a member has. Something like:

Select COUNT(ROWID) as count from posts WHERE MemberID = 0001

Now multiply that by the number of posts in a thread.

It starts to consume a great deal of memory. Whereas if you do this:

Select COUNT(ROWID) as count from posts WHERE MemberID = 0001 Limit 1000

You save a whopping load of memory.
Printer Friendly | Permalink |  | Top
 
DadOf2LittleAngels Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:26 AM
Response to Reply #22
29. Problem with your post..
The database has to do a read for every post regardless of where you set the (more than), when you load this it has to read my info to see if I even have 1000+ post..

Now if, on the other hand its doing a real time read of post by a table scan then it would be a problem but thats a real rookie way to set up a database! The SP for 'post message' should increment a counter on a cell in the user table..
Printer Friendly | Permalink |  | Top
 
ixion Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:05 PM
Response to Reply #29
33. only InnoDB types scan every entry... MyISAM doesn't do that.
there's a huge difference in performance. Using the aggregate COUNT function is very fast for MyISAM tables, and very, very, very slow for InnoDB type tables.
Printer Friendly | Permalink |  | Top
 
tachyon Donating Member (520 posts) Send PM | Profile | Ignore Fri Mar-14-08 10:43 AM
Response to Reply #22
32. How can it determine if it's under 1000 without reading it?
??
Printer Friendly | Permalink |  | Top
 
ixion Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:06 PM
Response to Reply #32
34. it's the other way around... it limits the result set... that is, as soon as it reaches 1K
it returns the result, rather than continuing through the entire db. Make sense?
Printer Friendly | Permalink |  | Top
 
Recursion Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:15 PM
Response to Reply #22
36. And before anyone gets a clever idea to save the post count in the user table...
Edited on Fri Mar-14-08 03:16 PM by dmesg
...that never works. You always wind up with bad data that way. Never store counts of countable resources. Except when it's a good idea to.

What you could do, though, is store a "1000+" flag in the user table. The posting process checks if the post is greater than 1000 and the flag is not set; if so, it sets it. Then the display code only has to look for that flag and won't bother counting in the first place.
Printer Friendly | Permalink |  | Top
 
CaliforniaPeggy Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:07 PM
Response to Original message
3. They used to show the whole post count...
Back when DU was new.

But it got unwieldy when people got up into the 10K range...

So this was decided on.

All of the info you seek is in the profile.

It's not intended to be discriminatory.

Printer Friendly | Permalink |  | Top
 
DB1 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:16 PM
Response to Reply #3
8. Thanks for the info. I new there was probably a good reason.
Maybe it should be revisited in light of all the new traffic.
Printer Friendly | Permalink |  | Top
 
Breeze54 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 10:38 PM
Response to Reply #8
23. DU goes into Defcon I daily now, as it is with the high traffic.
That would just make it worse.

:hi:
Printer Friendly | Permalink |  | Top
 
GreenPartyVoter Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 10:46 PM
Response to Reply #3
24. Some people really took the numbers to heart. I mean it just seemed like they
based their self-worth on it. "Ooooh, Look at me. I have lots more posts than anyone in this thread." :P

Printer Friendly | Permalink |  | Top
 
RC Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:12 PM
Response to Original message
5. Too many just post kicks all over the place to get their post counts up.
Edited on Thu Mar-13-08 04:14 PM by RC
very seldom to never saying anything.
Others clog the system with what really should be called spam, never saying anything either.

Anyway, don't worry about it. Be reasonable with your posts and you will be fine. (Not like that idiot in #1 above me.)
Printer Friendly | Permalink |  | Top
 
DB1 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:14 PM
Original message
Thanks. That above comes with the territory I guess.
Printer Friendly | Permalink |  | Top
 
Zywiec Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:14 PM
Response to Reply #5
7. K & R!!
:kick:
Printer Friendly | Permalink |  | Top
 
CreekDog Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 05:28 PM
Response to Reply #5
17. Some people write thousands of words
without saying anything. :eyes:
Printer Friendly | Permalink |  | Top
 
Dr. Strange Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:12 AM
Response to Reply #17
27. And most of their words...
just consist of criticizing great music, like, say, Rush.
Just saying...

:hide:
Printer Friendly | Permalink |  | Top
 
CreekDog Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:26 PM
Response to Reply #27
38. it's true that's wasted effort
since the truth is already self-evident. :evilgrin:

:pals:
Printer Friendly | Permalink |  | Top
 
Dr. Strange Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:45 PM
Response to Reply #38
44. Shouldn't you be watching someone shower?
Printer Friendly | Permalink |  | Top
 
Boojatta Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:14 PM
Response to Original message
6. Why do you propose showing the total number of posts?
It could show the number of posts up to nine and say "(10 + posts)" for people who have more than nine posts. Of course, there would then be a competitor for the Brazillion joke: "You don't trust me? But I've contributed more than nine posts!"
Printer Friendly | Permalink |  | Top
 
DB1 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:22 PM
Response to Reply #6
9. Combine the number of posts with membership date gives info...
Somebody becomes a member in March 08 and has 500 of posts they may be less credible than a 1 year member with 500 posts. imho
Printer Friendly | Permalink |  | Top
 
enlightenment Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:38 PM
Response to Reply #9
10. As the poster above suggested,
click on the profile icon and you'll see the date they joined and the number of posts (for the 1000+ crowd). If it says 2003, before July 3rd (or 6th, don't recall which) it just means they registered before they changed the way they listed post count (that was the day they did that, I think).

There are, unfortunately, a lot of people who hide their profiles. Considering that you can control what people see, that's a bit suspicious in my book, but I suppose they feel they have good reason.

Credibility isn't really about post count, though - and I know you realise that. It is tempting to dismiss someone who has a new membership date and a high post-count because you have to wonder where they find the time to make thoughtful posts. Maybe they aren't and in that case, fair to dismiss them. If I'm bothered enough by someone, I'll do a search on their username and get an overview of what sort of posts they make; that usually resolves the question. You do need to be a contributing member of DU to access the advanced features, though.

None of us are perfect; I know I've made my fair share of "me, too!" posts and I rarely write long, discursive essays or share my inner-most feelings about something with everyone (not criticising those who do, it's just not me). It is frustrating right now, particularly in GD-P. Things will settle down. Really. This too shall pass.
Printer Friendly | Permalink |  | Top
 
alstephenson Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:46 PM
Response to Reply #10
11. I'm a much happier DU'er since I blocked GD-P.
Try it, you'll like it!
Printer Friendly | Permalink |  | Top
 
Make7 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 04:58 PM
Response to Reply #10
12. RE: people who hide their profiles
It is possible to determine when someone signed up at DU even if their profile is hidden. This can be done because the member ID numbers are assigned sequentially to people as they register.

To use myself as an example, if you mouse over the icon to send me a private message (), you will see by the link's web address that my user ID is 145813. All you need to do is type in user ID's next to (or close to) mine in a view profile link.


http://www.democraticunderground.com/discuss/duboard.php?az=user_profiles&u_id=145812

http://www.democraticunderground.com/discuss/duboard.php?az=user_profiles&u_id=145814


You will find that user 145812 joined on Jun 18th 2004 and user 145814 also joined on Jun 18th 2004. Guess when I registered?

- Make7
Printer Friendly | Permalink |  | Top
 
crispini Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 05:03 PM
Response to Reply #12
13. Well, well, isn't that clever!
:D
Printer Friendly | Permalink |  | Top
 
enlightenment Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 05:27 PM
Response to Reply #12
16. Ah! Interesting!
Thanks for the info! I try not to conflate post count and membership date - I'm not a heavy poster, but I've been around DU for a long time . . . silly really, I can't even remember when I signed up, though I know it was about 6 months after I started lurking. CRS!

That said; the one doesn't necessarily relate to the other. Content is a more accurate measure than quantity, I think.
Printer Friendly | Permalink |  | Top
 
Make7 Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:30 AM
Response to Reply #16
30. Well, if something doesn't seem quite right about an unfamiliar poster...
... it sometimes is interesting to determine how long they have been around. But measuring someone merely based on their post count, their length of membership, or some relation of the two is a bit silly. Even if they do disagree with something (or everything) that has been said.

The inclination for me to reply is much greater when I strongly disagree with something that has been posted - but I do (hopefully) have the ability to outline some reasoning for my position. Although if I had a low post count, no doubt I would invariably be wrong regardless of what I had to say. :)

- Make7
Printer Friendly | Permalink |  | Top
 
LostinVA Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:12 PM
Response to Reply #10
35. I don't trust any poster without a profile
Printer Friendly | Permalink |  | Top
 
tammywammy Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:29 PM
Response to Reply #35
39. I don't really either LostinVA
:shrug:

Printer Friendly | Permalink |  | Top
 
LostinVA Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:30 PM
Response to Reply #39
40. They don't have to have any personal info in the profile
Just join date, post cost, sex or location is enough for me. To me, it seems like they're hiding more than their profile, if they disable it.
Printer Friendly | Permalink |  | Top
 
tammywammy Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:37 PM
Response to Reply #40
41. Agreed
That's all I have in mine: join date, # of posts, female & Texas. :shrug:
Printer Friendly | Permalink |  | Top
 
awoke_in_2003 Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:38 PM
Response to Reply #10
42. "a lot of people who hide their profiles"
And a lot of them are people who have been here two months. They are usually the rabid fans of (name a candidate) that have made this such a "wonderful" place lately
Printer Friendly | Permalink |  | Top
 
CreekDog Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 05:30 PM
Response to Reply #6
18. They should show how many Brazillion posts people have
:think:
Printer Friendly | Permalink |  | Top
 
madinmaryland Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:11 AM
Response to Reply #18
26. Really?
January 24th, 2009. In the oval office of the new Democratic president:

The Secretary of Defense is giving the President the daily briefing. He concludes by saying: "Yesterday, three Brazilian soldiers were killed."

"OH NO!" the President exclaims. "That's terrible!"

The President's staff sits stunned at this display of emotion, nervously watching as the President sits, head in hands.

Finally, the President looks up and says, "One Brazilian is too many! I am glad that we are beginning to draw down our presence in Iraq and put an end to this long national nightmare."

:evilgrin:
Printer Friendly | Permalink |  | Top
 
CreekDog Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:25 PM
Response to Reply #26
37. I swear you are a bot
:rofl:
Printer Friendly | Permalink |  | Top
 
Terran Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:44 PM
Response to Reply #26
43. That was a Bush joke originally.
Silly to change it as no one else could possibly be that dumb.
Printer Friendly | Permalink |  | Top
 
aquart Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 05:12 PM
Response to Original message
14. Big kids been picking on you?
So you want it known if you've been here five years with three posts or whatever? To give people a different basis for being snotty?

Of all the worthless things to fuss over.
Printer Friendly | Permalink |  | Top
 
DB1 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 07:35 PM
Response to Reply #14
20. Actually, no. Most my dicussions here have been nice.
But there are the occasional few I read or watch others respond to that are a waste of time. Why are you so angry?
Printer Friendly | Permalink |  | Top
 
CreekDog Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 05:27 PM
Response to Original message
15. You only have 306 posts
Are you a freeper?

(I j/k) :pals:?
Printer Friendly | Permalink |  | Top
 
DB1 Donating Member (1000+ posts) Send PM | Profile | Ignore Thu Mar-13-08 07:32 PM
Response to Reply #15
19. No. But I guess someone needed to ask.
Printer Friendly | Permalink |  | Top
 
Dr. Strange Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:13 AM
Response to Reply #19
28. The other thing that's nice about seeing who has a low post count is...
you can welcome them to DU.

So, welcome to DU DB1!
Printer Friendly | Permalink |  | Top
 
Make7 Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 09:02 AM
Response to Original message
25. A couple of DU 1.0 threads that may be of interest...
Printer Friendly | Permalink |  | Top
 
Javaman Donating Member (1000+ posts) Send PM | Profile | Ignore Fri Mar-14-08 03:46 PM
Response to Original message
45. Nice post, Hitler-newbie!! LOL nt
Printer Friendly | Permalink |  | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Mon May 06th 2024, 05:08 PM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » Archives » General Discussion (1/22-2007 thru 12/14/2010) Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC