GAE indexes properties automatically. Your best bet is to store your list of
strings as a Text or Blob with a separator and join/split when you read the
property. Text/Blob properties do not get indexed.
On Sun, Apr 5, 2009 at 3:49 AM, 秦锋 <feng.w....@gmail.com> wrote:
>
> All:
>
> Now my question is If I only use string list property as property,
> never index them, is it OK with space cost?
> P.S: I still got 3% space (30MB) used for 2500 records (300+KB) csv
> files.
>
> On 4月4日, 下午5时18分, Alkis Evlogimenos ('Αλκης Ευλογημένος)
> <evlogime...@gmail.com> wrote:
> > Remove the indexes from your index.yaml and run appcfg.py vaccum_indexes.
> >
> >
> >
> >
> >
> > On Fri, Apr 3, 2009 at 5:32 PM, 秦锋 <feng.w....@gmail.com> 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 ('Αλκης Ευλογημένος)
> > > <evlogime...@gmail.com> wrote:
> > > > What do your models look like?
> >
> > > > On Fri, Apr 3, 2009 at 2:00 PM, 秦锋 <feng.w....@gmail.com> 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
> >
>
--
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 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
-~----------~----~----~----~------~----~------~--~---
