We have been testing gql based datastore performance for a while now. I am very disappointed so for what performance we are getting from our simple un-ordered fetch/get.
Here is what we are doing- 1. Make a "kind" based query with no filter and ordering. We fetch all the entity (not just keys) as we need attributes of the entities too. 2. We use cursors with prefetch of 100 and chunk size 50. 3. Each entity is around 100k We get around 7 sec to 15 secs to prepare the query and iterate over it (100 entities). In the fetch loop, we dont execute much code to consume CPU at all. We also use asQueryResultIterator. My question is, is this a normal performance? Are others getting way better than this? If yes, that is terrible. Is there a way to improve it further? Thanks in advance... -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-j...@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.