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 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.

Reply via email to