Some of the search terms have many results, since there is no composite index merge-join is being used. Adding a compiste index would probably significantly increase the write-time overhead (search for exploding indexes).
Three thoughts come to mind: 1) Compute statistics so you can identify 'meaningless' search words and notify the user / drop them from the query. 2) Catch the error and tell the user they need to refine the search. 3) If your list of terms is very small, you could try to add the composite index. Not sure any of those ideas are good ones though... ;) Robert On Tue, Feb 22, 2011 at 02:33, Joseph <jssenya...@gmail.com> wrote: > Hi, > I have an entity kind that inherits from SearchableModel which > has 13,417,423 Entities whose single property indexes I disabled > (Indexed=False). > I have no composite indexes on this kind and all queries made on this kind > is via basic seach. > entities = > Kind.all().search(searchQ).fetch(self.PAGE_SIZE,offset=self.getPageOffset()) > > Searches do work well apart from certain specific search terms that fail > with error > NeedIndexError: The built-in indices are not efficient enough for this query > and your data. Please add a composite index for this query. > > Exception trace is attached. > Am an intermediate with App Engine development. Any help is appreciated. > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to google-appengine@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
