Top DD, second question.

[delems]

On top players DD, it shows 379 players on the list. But, the top personas DD only shows 29 players, and yet it includes all kills (while the top player I think just includes ea and eships).

Since there are 3 personas that can spawn DDs, there should be at most 3 times as many people in the persona list as player list. But our top player list has more than top personas, which should never happen.

What is going on here?

[GOPHUR]

Personas don't exist until they are spawned. Could that account for it?

I kinda wish that CSR2 showed all personas even if they don't exist yet so that it would be more uniform looking.

[delems]

My guess is the top persona lists require the 25 sorties in order to be included, while the top player lists includes anyone with one or more sorties, and thus more players showing.

Many of the previous top lists had minimum number of sorties before being included in the list.

[Eagletree]

My guess is the top persona lists require the 25 sorties in order to be included, while the top player lists includes anyone with one or more sorties, and thus more players showing.

Many of the previous top lists had minimum number of sorties before being included in the list.

There may be top player lists that aren't honoring the minimum sortie requirements. Exactly the same issue we were discussing with the many to one relationship of captures to player. The reports were initially built totally ignoring the number of sorties and ran pretty quickly. I may have missed some when the minimums were added back in because several vehicles used completely different queries than the infantry reports.

It's all somewhat moot, because I've decided to give up and build batch reports for the Top Player lists since that can be started immediately; it has no dependencies to a new database or the campaign switchover. This will allow me to match up the data through conventional methods using the disk storage on the new server. It will depend on how long each batch run takes, but I assume it will be every 30 minutes, that a new set of Top Player reports will be generated. No estimate on when this will be done. As long as I'm doing this, I'll revert personas to the same processing since that is all existing code from CSR 1.0. We already know those will run on 15 minute intervals.