This is after deployment and not local. The locals fly fast. No issues there.
As to your second point- I set the prefetch to 50/100 etc and also chunk size. The limit for the qry is also set to large value. But as you suggested, I will do app stat. On Apr 26, 4:17 pm, "Ikai L (Google)" <ika...@google.com> wrote: > 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 <mkhad...@gmail.com> wrote: > > BTW, the duration of the query fluctuates a lot. 2 sec to 15 secs. > > > On Apr 26, 10:05 am, mandar khadilk <mkhad...@gmail.com> 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 > > google-appengine-j...@googlegroups.com. > > > To unsubscribe from this group, send email to > > google-appengine-java+unsubscr...@googlegroups.com<google-appengine-java%2B > > unsubscr...@googlegroups.com> > > . > > > 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 > > google-appengine-j...@googlegroups.com. > > To unsubscribe from this group, send email to > > google-appengine-java+unsubscr...@googlegroups.com<google-appengine-java%2B > > unsubscr...@googlegroups.com> > > . > > 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 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 > 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 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.