Hmm... i understand the problem. But, if i want to query using a text with multiple words and NO sorting order, i use the build-in index supplied default right ? So, what do i do for 90.000 entities ?? because it seams that the build-in index is not powerful enough !
"The built-in indices are not efficient enough for this query and your data. Please add a composite index for this query.. An index is missing but we are unable to tell you which one due to a bug in the App Engine SDK. If your query only contains equality filters you most likely need a composite index on all the properties referenced in those filters." So the solution is creating a index like this: keyWordsList ▲ , keyWordsList ▲ , keyWordsList ▲ Isn't this really the "build-in" index ? On Sep 24, 5:16 pm, Cyrille Vincey <[email protected]> wrote: > You're facing the exploding indexes problem. > You should never put more than 1 list properties in one composite index. > > This problem is described in the GAE > doc.http://code.google.com/intl/fr-FR/appengine/docs/python/datastore/que... > dindexes.html#Big_Entities_and_Exploding_Indexes > > On 24/09/10 15:54, "Ice13ill" <[email protected]> wrote: > > >I'm trying to implement a search based on a list of keywords (string). > >The list is created based on the content of the objects' fields and i > >use it when matching against a query text. > >The problem is that i can't create indexes on App engine (i get Error > >after about 30 mins, and i have to delete it). There are about 90,000 > >entities of that kind and the index should looke like this: > > >keyWordsList ▲ , keyWordsList ▲ , keyWordsList ▲ , key ▼ > > >and i have about four of them. > > >My question: do i want to much ? :) I tried uploading about 4 indexes > >and i got Error. I tried uploading 1 and worked (but needed about 2-3 > >h). Is there a problem if i try to create 4 indexes of this magnitude > >(and why)? Can i be sure that uploading one by one will work? Or maybe > >this problem is related to AppEngine datastore problems ? > >Please advice ! > > >-- > >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 > >[email protected]. > >To unsubscribe from this group, send email to > >[email protected]. > >For more options, visit this group at > >http://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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
