our user account has many fields like userName, email, number, alternate email list, ids from social networks like facebook, google, twitter, linkedin etc. The primary key is one of those fields. In "realtime", we should be able to find if a user exists with any the fields and not just email. One thing I could do it td create a datastore index for each of the field that I want to lookup and then perform the query when needed. Having many indexes means more number of low level datastore write calls for each store hit. And the sql query won't be fast if there are are too many records.
Anyway, thanks for your comments. I will look to see if I can design it differently. -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-appengine-java/-/1u39C_iNYtIJ. To post to this group, send email to google-appengine-java@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.