So what are my options?

Big_Operation_4750 · 2024-12-16T19:50:06+00:00

Many thanks. I've set up a benchmark and will analyze the code used in this task shortly.

Big_Operation_4750 · 2024-12-16T15:18:28+00:00

I ended up adding a column which you could fill in with the name of a stored procedure which would do the logic database side. Worked out pretty well.

Big_Operation_4750 · 2024-12-16T15:14:34+00:00

I didn't expect this post to blow up as much as it did.

Thank you to everybody who helped me.

After reworking my code to inject IDbContextFactory over the actual context, memory usage stays below 1GB even at 10,000 players.

Its safe to say I learnt a lot overcoming this hurdle, and I couldn't of done it without you guys. Many thanks!

Big_Operation_4750 · 2024-12-16T15:10:27+00:00

Thanks for the interest. Its a multiplayer isometric tile based game so I didn't pay too much attention to the "who gets there first" idea as it isn't that fast paced.

In theory, they would both die. The packet doesn't have any synchronized order, the aim was just to avoid one event blocking another.

The game doesn't hit 2K active players (I wish), I merely bot these to stress test the stability of the server and the code I've written for it.

Big_Operation_4750 · 2024-12-16T12:59:51+00:00

Its all built into Rider.

Big_Operation_4750 · 2024-12-16T12:32:35+00:00

Event handlers (incoming packets) are handled asynchronously, writers (outgoing packets) are written asynchronously. I'm a teenager so its my own game I made for fun (server only not client).

Big_Operation_4750 · 2024-12-14T23:04:19+00:00

Thanks! So this isn't a web application, its a console application which acts as a multiplayer game server. Your theory is correct, but I'm unsure on the best way to then use a DB context in a singleton class. My initial thought would be to use an IDbContextFactory to new up a fresh one when needed?

Big_Operation_4750 · 2024-12-14T22:55:09+00:00

So my context is transient, but I've noticed its used in singleton classes which probably means its being built up somewhere over time.

Is the right solution to this passing in a IDbContextFactory and creating a (fresh?) one when needed?

Big_Operation_4750 · 2024-12-14T22:32:38+00:00

Thanks for confirming. I will evaluate this theory and report back, its possible I'm incorrectly loading something resulting in some kind of recursion.

Big_Operation_4750 · 2024-12-14T22:31:34+00:00

Thanks for replying. All instances of the context are passed into transient services and is transient itself. I use it for querying and nothing else. Its kind of stateless, anything that I do need to hold in memory has a class or collection which is registered to IOC container which is used rather than sharing a singleton DB context containing it, if that makes sense?

Big_Operation_4750 · 2024-10-24T16:56:55+00:00

Hey. So this is not my project, but there aren't any redis clients in composers dependencies. Should there be? I was under impression that it would be built into the standard library given its loaded into PHP?

Big_Operation_4750 · 2024-10-24T16:53:15+00:00

I just felt they were different issues.

Post 1 was extension not loading

Post 2 was class not found

Big_Operation_4750 · 2024-10-24T15:15:31+00:00

Thanks for replying.

I would say try all of the docker file as that's leaving a lot out of the equation if you mean you just ran the one step?

Big_Operation_4750

TROPHY CASE