Are you doing this locally or after deployment? Check out this tool: http://code.google.com/appengine/docs/java/tools/appstats.html
<http://code.google.com/appengine/docs/java/tools/appstats.html>You'll be able to use this to identify bottlenecks. It's possible you're fetched each entity individually, for instance. On Mon, Apr 26, 2010 at 2:40 PM, mandar khadilk <[email protected]> wrote: > BTW, the duration of the query fluctuates a lot. 2 sec to 15 secs. > > On Apr 26, 10:05 am, mandar khadilk <[email protected]> wrote: > > 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 > [email protected]. > > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > > For more options, visit this group athttp:// > groups.google.com/group/google-appengine-java?hl=en. > > -- > 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 > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > -- Ikai Lan Developer Relations, Google App Engine Twitter: http://twitter.com/ikai Delicious: http://delicious.com/ikailan ---------------- Google App Engine links: Blog: http://googleappengine.blogspot.com Twitter: http://twitter.com/app_engine Reddit: http://www.reddit.com/r/appengine -- 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 [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-java?hl=en.
