Hi, These indexes are appearing because you are using multiple keywords in your search, each of which needs a __searchable_text_index field in an index entry. And you are right, these will result in exploding indexes.
The bottom line is that searchable model can only realistically be used for one or two word searches before resulting in an exploding index. -Marzia On Sat, Jan 3, 2009 at 8:56 PM, Ferdhie <[email protected]> wrote: > Dear All > > I don't know why, but everytime I run at localhost, the index.yaml kept > generating so many __searchable_text_index Index > It will cause error while I update index on appengine servers (perhaps > because of exploding index) > > Here's my model > class Entry(search.SearchableModel): > STATUS_CHOICES = ( > ('draft'), > ('public'), > ('private'), > ) > > COMMENT_STATUS_CHOICES = ( > ('open'), > ('close'), > ('password'), > ) > > PING_STATUS_CHOICES = ( > ('open'), > ('close'), > ) > > ENTRY_TYPE_CHOICES = ( > ('post'), > ('page'), > ) > > author = db.UserProperty() > author_name = db.StringProperty() > title = db.StringProperty() > slug = db.StringProperty() > body = db.TextProperty() > postdate = db.DateTimeProperty() > postdate_gmt = db.DateTimeProperty() > excerpt = db.TextProperty() > status = db.StringProperty(default='draft', choices=STATUS_CHOICES) > commentstatus = db.StringProperty(default='open', > choices=COMMENT_STATUS_CHOICES) > pingstatus = db.StringProperty(default='open', > choices=PING_STATUS_CHOICES) > commentcount = db.IntegerProperty(default=0) > tags = db.ListProperty(db.Key) > entrytype = > db.StringProperty(default='post',choices=ENTRY_TYPE_CHOICES) > year = db.StringProperty() > month = db.StringProperty() > day = db.StringProperty() > > > Here's the index > # Used 7 times in query history. > - kind: Entry > properties: > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: entrytype > - name: postdate > direction: desc > > # Used 6 times in query history. > - kind: Entry > properties: > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: __searchable_text_index > - name: postdate > direction: desc > > # Used once in query history. > - kind: Entry > properties: > - name: __searchable_text_index > - name: __searchable_text_index > - name: postdate > direction: desc > > # Used 4 times in query history. > - kind: Entry > properties: > - name: __searchable_text_index > - name: entrytype > - name: postdate > direction: desc > > # Used 11 times in query history. > - kind: Entry > properties: > - name: __searchable_text_index > - name: postdate > direction: desc > > # Used once in query history. > - kind: Entry > properties: > - name: postdate > direction: desc > > The question: > 1. How to suppress those many2 autogenerated __searchable_text_index > 2. Or maybe I make some mistake in design? > > Thanks, > > -- > Herdian Ferdianto > http://beta.ferdianto.com > http://www.id-snippet.com/ > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
