CS&R 2.0 Alpha Player Top lists

[delems]

The player top lists (for example LMG) does not seem to include all the captures or sorties from all branches, it seems to just show the army capture and sortie numbers; yet, the kills is from all branches.

However, the player top list for captures and sorties does get all the branches - so the data is there.

[Eagletree]

Thanks Delems. I figured there were capture and sortie problems on the player versions of the lists. They were way too slow if done like the persona lists were. That's a good description though, and I should be able figure it out.

It's helpful to have people validating and reporting.

Edited October 10, 2013 by Eagletree

[Eagletree]

The sorties and caps are corrected on all the reports that use them. It's a dramatic change in placement due to the impact of captures and the fact that many players had significantly more captures in personas beyond their first. It also made more players qualify for the top list, but that is minor impact.

The reports are still unverified, but catching that took a large step toward doing so.

This appears to have slowed performance of these queries by 2x+, but we will improve that when the new database is up. There are other more far more serious performance issues right now that will overshadow minor performance issues like this.

[mingus]

Would be cool to see total sorties flown, like the old list. And when you see who youve killed, what unit they were using would be sweet to see too.

[Eagletree]

Would be cool to see total sorties flown' date=' like the old list. And when you see who youve killed, what unit they were using would be sweet to see too.[/quote']

I understand what you are looking for on the latter half of that, that's doable except for the space in sortie detail, I avoided including some information just because of real estate, the weapon used by the person you killed is available with the kill name so it's as good as there. But let me know which report you mean for the sorties total issue. It's probably an oversight if it was there and isn't now.

[mingus]

I understand what you are looking for on the latter half of that' date=' that's doable except for the space in sortie detail, I avoided including some information just because of real estate, the weapon used by the person you killed is available with the kill name so it's as good as there. But let me know which report you mean for the sorties total issue. It's probably an oversight if it was there and isn't now.[/quote']

In the old players top lists you had stuff the new list has such as, kills, deaths, k/d. But in the old one there was a field that showed how many sorties were flown by the person. As it is now it looks like person A. may have 20 more kills than person B. But what you dont see is that Person B hasn't flown nearly as many sorties. ( He has a job, lol) His performance could be equal to Person A. based on number of sorties flown, but you wouldnt know it because it only shows deaths and kills..

[Eagletree]

In the old players top lists you had stuff the new list has such as' date=' kills, deaths, k/d. But in the old one there was a field that showed how many sorties were flown by the person. As it is now it looks like person A. may have 20 more kills than person B. But what you dont see is that Person B hasn't flown nearly as many sorties. ( He has a job, lol) His performance could be equal to Person A. based on number of sorties flown, but you wouldnt know it because it only shows deaths and kills..[/quote']

Got it. I dropped sorties off as a convenience because it was tough to make it work with these versions operating interactively (the CSR 1 batches all the top lists so they are always out of date). It's doable though, will just take a little time.

[delems]

Yes, must have sorties listed on top player lists (and just the sorties for that weapon) - otherwise many awards will be impossible to calculate and given. And I haven't earned all the KM awards yet

[mingus]

Got it. I dropped sorties off as a convenience because it was tough to make it work with these versions operating interactively (the CSR 1 batches all the top lists so they are always out of date). It's doable though' date=' will just take a little time.[/quote']

Sweet, hope this works out.

[delems]

Looking at the top player LMG list the total number of sorties and captures is now there, BUT, the sorties are all sorties for the player, not just all LMG sorties; in the top lists, the number of sorties must just be from that weapon type.

Also, even worse, the report no longer shows the total number of kills from all branches.

What seems a bit odd - is under the weapon summary for player (i.e. me); all the LMG stats per branch are summed correctly as is number of LMG sorties it seems.

Edited October 21, 2013 by delems

[Eagletree]

Looking at the top player LMG list the total number of sorties and captures is now there, BUT, the sorties are all sorties for the player, not just all LMG sorties; in the top lists, the number of sorties must just be from that weapon type.

Also, even worse, the report no longer shows the total number of kills from all branches.

What seems a bit odd - is under the weapon summary for player (i.e. me); all the LMG stats per branch are summed correctly as is number of LMG sorties it seems.

I've got the entire Top Player menu on hold until Camp 96. I need to use a temp table and that requires write access. With the db loaded down with data from 94 and 95, I can't even offload it to do testing prior to the changes. It all has to do with what I mentioned about not wanting to batch the reports. I'm trying to keep them interactive and I can't get a fast enough query without a temp table (actually, I don't even know for certain if that will do it yet). I found a way to generate the report accurately, but it took several minutes.

I'll see if I can switch it back to one of the interims I tried that was close. Not good to leave it out there that way.

[delems]

===

I've got the entire Top Player menu on hold until Camp 96.

===

Ok, I understand, but the whole point of stats is top player lists... so without it, it sort of is like no stats at all.

Sounds like you are running out of DB room? Terabyte drives are pretty cheap now a days... 4Tb external drives with firewire 800 around $350.

Can you filter just the last 40 days or so, i.e. just map 95 stats?

[Eagletree]

===

I've got the entire Top Player menu on hold until Camp 96.

===

Ok, I understand, but the whole point of stats is top player lists... so without it, it sort of is like no stats at all.

Sounds like you are running out of DB room? Terabyte drives are pretty cheap now a days... 4Tb external drives with firewire 800 around $350.

Can you filter just the last 40 days or so, i.e. just map 95 stats?

The server that CSR 2 is on is new and has plenty of storage. Unfortunately the old server doesn't and even unloading the db via dump exhausts temp table space. Even using a remote client still taxes the db instance on the server the data is resident on. When the camp reset occurs and 94 and 95 are cleared, we hope to pull the data and put it on the new machine and track changes in parallel via replication.

[mingus]

The server that CSR 2 is on is new and has plenty of storage. Unfortunately the old server doesn't and even unloading the db via dump exhausts temp table space. Even using a remote client still taxes the db instance on the server the data is resident on. When the camp reset occurs and 94 and 95 are cleared' date=' we hope to pull the data and put it on the new machine and track changes in parallel via replication.[/quote']

Hoping the new camp change works out some stuff for ya. The old list had far more info, including number of sorties and which branch player was playing, like British air or German air, etc. good luck in working it all out!

[delems]

===

and which branch player was playing

===

Top player reports include all branches from both sides, there is no delineation. Top persona shows branch.

[Quincannon]

Just for informational purposes...

Top engineers (Persona) Only shows the top 79, where rifleman and others show more than 100.

Also, Top DDs (persona) identifies everyone as being army.

I understand there are problems, but I thought you might want to know.