Hi Venkatesh, What is the full query that your trying to execute that is giving the error? If it's not a field that contains multiple values I'm not sure what that type of index would do since a single value property would have the same value repeated again and again in the index. What am I missing? Stephen
On Jul 29, 9:55 pm, Venkatesh Rangarajan <[email protected]> wrote: > Stephen, > > Yes, that is correct. I have only one index. I am not doing any > sorting or filter or anything. > > Total size of all records is close to 1 million records. Raw data > size is i think 500MB. I had uploaded part of the data when Appengine > launched. Abandoned it frustrated with data time out and lack of > search etc. Thought it would be a good time to re-try. > > I don't have multi-property field. > > I did not have too create that index, it was added in the index file > automatically because I am using Searchable Model. Now inspite of > this, i kept getting the following error. > > NeedIndexError: The built-in indices are not efficient enough for this > query and your data. Please add a composite index for this query. > This query needs this index: > - kind: Jobs > properties: > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > > I manually added, that to index file and that resulted in exploding > index. That index error-ed out and I have vacuum it long back. > > None of this explains how 1gb of data gets translated to 28gb of data > in appstore. I have another 3 gigs of raw data, sitting on my > hard-disk which i am afraid to upload, since I am not sure it would > scale. > > rgds, > Venkatesh -- You received this message because you are subscribed to the Google Groups "Google App Engine" 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?hl=en.
