7M updates

General Discussion Area
Post Reply
1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

7M updates

Post by 1974ER »

It's now time for the next xM thread, as 7M updates marker breaks today. :D

User avatar
Rollie
Site Admin
Posts: 4783
Joined: Sun Nov 28, 2004 11:52 am
Location: Austin, TX
Contact:

Post by Rollie »

Ha, nice work =)
phpbb:phpinfo()

Hybuir
Gear Dependent Squirrel
Gear Dependent Squirrel
Posts: 1471
Joined: Tue Sep 06, 2005 6:22 am
Location: Austin, TX
Contact:

Post by Hybuir »

Good job well done, sir!

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Grats! :)

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Almost a year later, looks like I've finally broken this barrier - 6,997,717 + 3,027 should've done it anyway :)

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

According to my math skills... that is indeed enough. Congratulations Balgair! :D

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Yep, it's updated now, finally made it! ;) Next target: beating my personal best censuses in a month (which I believe may also be the WCR highest total, will have to check that out :P)

Edit: yep, my updates per month best of 837,062 is a WCR record, Kerebo holds the new ones record of 145,482. Some nice targets for me before Cataclysm hits and I barely leave my home server for a while ;)

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

Hehehe, well, at your current rates... You'll break Kerebo's record in a few days as you already have over 120k new ones... and your personal updates record would break around 26th, 27th or 28th, roughly.

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Yeah think I'll get the new ones, not so sure on updates, since I'm starting to play my main characters again, dammit ;) Amazed how many new ones I'm getting here, must be hitting the right servers I guess!

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

Actually... If I am reading the Census database data correctly... you are getting so many updates and new ones because YOU are doing a lot... but overall... we are losing results. Unless I am badly mistaken... we are down over 400k entries in past 7 days and that loss has happened in less than 3 days. :(

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Bear in mind the database is about 2 days behind reality atm, so depends if it's saying the last 7 days before the last processed entry, or the last 7 days, out of which t hasn't processed a lot of entries yet ;)

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

That's the catch... it's working on processed values, at least for some things. Because, otherwise, the number of factions updated in the past 24 hours would be 0 for both Horde and Alliance... and both of those values are close to 300. :D Which in turn means that in the past 24 hours, approximately 600+ censuses have processed. I say 600+, because it's a fact that some factions have gotten more than one update in that time period as I, you and several other people have made more than one submission within the last 24 hours that have been processed.

If the same applies to the number seen... it has dropped by about 400k in the last about 3 days (actual, not processed). And if it actually uses days... the problem is even worse... you see, I took a quick count and made a rough estimate based on certain rule of thumb I have found fairly accurate in the past. Provided I didn't make any major mistakes... you and I, between just the two of us... are resposible for approximately 740k characters seen in the past 7 (excluding the unprocesssed files) out of the roughly 1,3 million that have been seen.

That would mean that the two of us would have handled more than 50% (actually almost 60%) of all incoming info that has already been processed after November 7th. That, to me, seems a tad high, don't you think?

The "joke" is... even if I dropped to the value of new + updated, we two would still be looking at almost 370k entries total (and we both know that we produce a lot of data that is neither new nor an update, but would still count as seen). 370k still equals almost 30% of 1,3M. And yes, I did already realise that we have certainly updated some characters more than once even in just a few days... but it's still a huge chunk of the total.

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Eek, yeah, hmm, sounds a bit strange, I know we update more than anyone else but... ouch! That said, I think something's a bit off with that, given Anonymous has 952,046 updates and 237,400 new ones this month, which would have to be only the first 13 days of the month, looking at where the database has got up to so far - halving that for an average would suggest Anonymous alone has equalled/outcensused the two of us, and there's plenty of logged-in users as well! Would seem to me as though perhaps the last 24 hours goes on last 24 hours of processed data, but 7 days might be realtime 7 days, of which only 5 days has been processed?

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

That pretty much has to be the reason... as... if my memory isn't utterly wrong... compared to late yesterday evening, the total number of characters in the database has grown by less than 9000, while the number seen has dropped by about an additional 100k and the number created by about 50k.

Additionally, the queue is now almost 43 hours behind, up from about 34 hours of backlog yesterday.

Also, on the montly scale... We two have 154 581 new ones and 634 342 updates so far, giving us about 3/5 of anonymous figure on new ones and almost exactly 2/3 of anonymous updates figure.

Given some of my earlier calculations: I am predicting roughly following total spread:

45% anonymous
30% you and I (you with a bit over 20%, me around 8-9%)
16-18% rest of the top 10s
7-9% everyone else combined

I fully admit that my calculations could be badly off... but here are a couple of interesting facts: You have more new characters so far than ENTIRE REST of the top 10 combined (myself included)... and on the updates list... it takes me and FIVE other people to roughly match your figure.

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Lol wow, I hadn't added up the new ones, though I knew I was fairly well ahead ;) If only I could keep up this level of censusing forever we'd have a lot less issues with lack of accuracy, but... it's too intense really, I'm only managing as much as I am because I'm playing WoW a lot less (taking a break before Cataclysm, since I know I'll play nonstop from release until I go away for Xmas holidays :P), and it won't last! Oh well, at least it should help things a little in the meantime :)

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Balgair wrote:Edit: yep, my updates per month best of 837,062 is a WCR record, Kerebo holds the new ones record of 145,482.
146,659 new ones :D Still not sure if I'll make the updates one, it's so far behind it's really quite hard to tell where I actually am, but it's probably still on target... I think? ;)

1974ER
Epic Censi
Posts: 762
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

147,827 for you at the moment I started typing this. :D Also, you are already at 556,359 updates, with seven submission currently fully unprocessed... at a steady pace, that would result in excess of 834,500 updates, meaning almost exact draw with you current record of 837,062. Considering that there are multiple unprocessed submissions and the 20th has barely began in the EU, I would say you still have a very good chance to bypass your previous record.

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Hehe I hope so but we'll see, I'm slowing down a bit atm because I'm playing my main server again, what with elemental invasions and needing to do a few things before they're gone ;) Hoping I can make it though, we'll see! I still say with enough dedication, 1 million in a month is possible... I'm just not sure that this month is the month ;)

User avatar
Rollie
Site Admin
Posts: 4783
Joined: Sun Nov 28, 2004 11:52 am
Location: Austin, TX
Contact:

Post by Rollie »

You guys are right on the money considering numbers. I'm working on increasing update speed again by doing more culling. will keep ya updated.
phpbb:phpinfo()

Balgair
Araiceil
Posts: 1716
Joined: Fri Sep 30, 2005 11:47 am
Location: UK

Post by Balgair »

Final contribution for the month is in: 766,597 updates, 195,807 new ones. Totally smashed the new ones record, updates only missed by a smallish amount, think that one would've gone too without the 1-29 deal, oh well, was still my 2nd best! :D

Post Reply