Thanks for the testing and benchmarking Takashi! Considering B4 = 4x B1 (we not really, but this is to illustrate a point!) ... and you had 20 of them, you effectively managed 200 QPS with 80 x B1's..... that's umm... 2.5 QPS each ?!? That's crazy! I think I see a performance development project in someone's future :)
On Thursday, August 2, 2012 12:50:53 PM UTC-4, Takashi Matsuo (Google) wrote: > > On Fri, Aug 3, 2012 at 12:46 AM, Richard <[email protected]> wrote: > >> Well, I tried to save Score() objects with a key name equal to the >> username (guaranteed unique) last night. GAE had the same problem in the >> wee hours of the morning when (most) of my users are not playing (only >> around 100-150 people playing). So, apparently it is not a tablet issue. >> >> Time to play with Cloud SQL maybe ? > > > That's a good idea. Certainly 1k QPS is something Cloud SQL can handle > theoretically, and Cloud SQL has a strong consistency which is important > for your use case. I should have came to this conclusion earlier. Sorry > about that. I'll try to experiment with Cloud SQL tomorrow and get back to > you. > > BTW, I have dome some experiment withs in-memory score server using > backend instances, and it constantly marked around 200QPS with 20 B4 > backends. So it might not be a good fit for your need this time. > > -- Takashi > > >> >> On Thursday, August 2, 2012 12:36:04 AM UTC-4, Richard Watson wrote: >>> >>> If you reverse the user id on saving the score, it'll be random and >>> you'll avoid the tablet issue. >>> >>> On Wednesday, August 1, 2012 9:52:24 PM UTC+2, Richard wrote: >>>> >>>> Hi Takashi, >>>> Yeah, the first few characters would probably be very similar. I am >>>> not sure if that would be a problem ? >>>> >>>> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/google-appengine/-/BBYrAdRDF0EJ. >> >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/google-appengine?hl=en. >> > > > > -- > Takashi Matsuo > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/eIvPq4dCXqAJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
