Indexes aren't indexes in the relational sense - indexes mean that they'll allow your application to find the data in the non-relational datastore.
Query performance locally uses a datastore stub, and the performance of a read can be dependent on the number of totally entities locally. What is the performance when deployed? On Fri, Apr 16, 2010 at 7:36 AM, Jonas Gehring <jonas.gehr...@egotec.com>wrote: > Hello. > > Our app is slow. I used a profilier to find the weak point. > The following query needs about 500ms on my local machine: > > SELECT FROM Employee WHERE account=:mail > > Account is a String field. > > Why is that query so slow? > > I also tried to set an index, but nothing changed: > <datastore-index kind="Employee" ancestor="false"> > <property name="account" direction="asc" /> > </datastore-index> > > > Could you please help me? > > Thanks. > > -- > 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%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > -- Ikai Lan Developer Programs Engineer, Google App Engine http://googleappengine.blogspot.com | http://twitter.com/app_engine -- 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.
