So there were 2 different "tables" with different field structures and the error appeared on exactly the same queries ?
On Apr 12, 2:54 pm, Alexandru Farcas <alexfarca...@gmail.com> wrote: > Hello, i have a problem with default indexes when executing a query > with equality filters on a list of properties. > > When querying a table with about 30000 entities I get the response > without errors, but after the table reaches 90000 entities the query > returns the error "The built-in indices are not efficient enough for > this query and your data. ...". > The entities have a list of about 30-40 keywords, and the queries have > about 3-4 eq filters. > > For example: SELECT __key__ FROM MyKeywords WHERE keyWordsList = 'leg' > AND keyWordsList = '53' AND keyWordsList = 'cod' AND entityName = Law > > I migrated from Master/Slave to HR. The error still appeared on the > SAME queries. > I created another table for the keywords (where i introduced the > "entityName" field inside the list of properties): exactly the same > behaviour... > Can someone tell me what i'm doing wrong ? -- 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.