Yes, it seems that list property searching will cost index space too
much.
On 4月4日, 下午5时18分, Alkis Evlogimenos ('Αλκης Ευλογημένος)
<[email protected]> wrote:
> Remove the indexes from your index.yaml and run appcfg.py vaccum_indexes.
>
>
>
>
>
> On Fri, Apr 3, 2009 at 5:32 PM, 秦锋 <[email protected]> wrote:
>
> > My models:
> > class Tag(db.Model):
> > name = db.StringProperty()
> > refCount = db.IntegerProperty(default = 0)
>
> > class Record(db.Model):
> > date = db.DateTimeProperty()
> > dfmt = db.StringProperty()
> > value = db.FloatProperty()
> > unit = db.StringProperty()
> > tags = db.StringListProperty()
> > source = db.StringProperty()
> > inputtime = db.DateTimeProperty(default = datetime.datetime.now())
>
> > class History(db.Model):
> > tags = db.StringListProperty()
> > qcount = db.IntegerProperty(default = 1)
> > found = db.BooleanProperty(default = True)
>
> > And following is my index:
>
> > indexes:
>
> > # AUTOGENERATED
>
> > # This index.yaml is automatically updated whenever the dev_appserver
> > # detects that a new type of query is run. If you want to manage the
> > # index.yaml file manually, remove the above marker line (the line
> > # saying "# AUTOGENERATED"). If you want to manage some indexes
> > # manually, move them above the marker line. The index.yaml file is
> > # automatically uploaded to the admin console when you next deploy
> > # your application using appcfg.py.
>
> > # Used 8 times in query history.
> > - kind: History
> > properties:
> > - name: found
> > - name: qcount
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: __key__>=
> > - name: __key__
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: date
> > - name: __key__
>
> > # Used once in query history.
> > - kind: Record
> > properties:
> > - name: date
> > - name: tags
> > - name: __key__
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: date
> > - name: tags
> > - name: tags
> > - name: __key__
>
> > # Used 6 times in query history.
> > - kind: Record
> > properties:
> > - name: inputtime
> > - name: __key__
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: __key__
>
> > # Used 10 times in query history.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: date
>
> > # Used 8 times in query history.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: date
> > - name: __key__
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: tags
> > - name: __key__
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: tags
> > - name: date
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: tags
> > - name: date
> > - name: __key__
>
> > # Used 2 times in query history.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: tags
> > - name: tags
> > - name: date
>
> > # Unused in query history -- copied from input.
> > - kind: Record
> > properties:
> > - name: tags
> > - name: tags
> > - name: tags
> > - name: tags
> > - name: date
>
> > I'm a newbie here, can I delete index as "Unused in history"?
>
> > On 4月3日, 下午8时50分, Alkis Evlogimenos ('Αλκης Ευλογημένος)
> > <[email protected]> wrote:
> > > What do your models look like?
>
> > > On Fri, Apr 3, 2009 at 2:00 PM, 秦锋 <[email protected]> wrote:
>
> > > > My App: cndata4u.appspot.com
> > > > Now I have imported about 2500 records there, and with only THREE
> > > > entities. But I have found that these data have occurred 20% data
> > > > store, about 200M!
> > > > My original CSV files have only 308K!
>
> > > > Any idea?
>
> > > --
>
> > > Alkis
>
> --
>
> Alkis
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
