Patrick DiPersio

Yep, composer fix definitely seemed to have went above and beyond. I can see if I can pull out those changes.

@wescopeland additional changes added by `composer fix` have been removed.

Got it. I can investigate the SQL as well to see if there's any way to optimize it. What's curious is that this query pulls from player_games, which seems to...

I made some minor optimizations to the queries, and they seem to be executing faster, but I'll need to set up some volume testing on my end to be sure....

No worries! I'm going to break this off into another branch to play around with. Hopefully I can figure something out that's more performant. 😁

Ok, I was able to insert about 25k rows into player_games for game_id 1 with a variety of unlock combinations, and I'm definitely seeing the performance hit now!  ...

Hey @wescopeland ! I did some extensive testing/tinkering with the Achievement Distribution query and as the data is currently structured, I'm not sure we'd be able to get the selection...

Great! I can start researching the write phase steps this week. I may reach out for guidance on a few things if I hit a wall, but I'll be sure...

@wescopeland a PR for the Write Phase (#2477) has been submitted. If/when the new PR is approved and merged, I can update this PR to accommodate the changes. Just let...

@wescopeland circling back to this and after some testing, it seems like the automatic "Soft Delete" check when selecting from the `player_games` table using Eloquent and the PlayerGame model is...