Forum ‹ BigDB ‹ more than 1000 requests per second. can BigDB handle that?

[-Mani]

Hey,

I'm planning on replacing my current account database (php+mysql) with the neat BigDB system.
Since my game has quite a lot of traffic, there are more than 1000 database-requests per second, i'm wondering if the BigDB servers will be cool with that. not that i'd ever doubt the performance of the player.io service, but i want to make sure.
And what's the average traffic size for a single request (store a few integers to the database for example)?

Thank you very much,
Manuel Otto

[Oliver]

Sure, no problem. Bring it on.

[-Mani]

Hey Oliver,

since your one of the developers of the BigDB system, i assume, you know how big a request is, right?
Okay, image, i'm telling the server to set the "highscore" variable to 3000.
How big would that request be?
300bytes?
500bytes?
1k?
Something around that?

Thank you,
Manuel Otto

[Oliver]

The actual command will be very few bytes, let's say 30 bytes (probably less: "highscore" = 9 bytes + value (1-8 bytes depending on long/int etc, lets say 2 bytes) = 2 bytes + misc overhead = a few bytes)

Most of your traffic in this case will be used by the HTTP overhead of performing a request which is around a few hundred bytes depending on your browser and proxy setup.

- Oliver