Hi Ed, To use a property in an explicitly written index that property must also be individually indexed. Stephen
On Fri, May 6, 2011 at 10:10 AM, Edward Hartwell Goose <ed.go...@gmail.com>wrote: > Thanks Robert, I've starred that issue. > > I wouldn't say each of the property names is particularly long > (probably 10-15 chars) but I suppose over a huge index this multiplies > up. I'm surprised that its 7GB for only one entity and it's property > names. Very surprised. > > Other than naming every property a one letter char (a, b, c etc), is > there any other solution? > > As for the unindexing - how does that affect explicitly written > indexes in the datastore-indexes file? If I remove indexing on all the > properties, but explicitly write the 5 queries in datastore-indexes, > will that still work? > > Thanks for the help, > Ed > > > > On May 6, 4:28 pm, Robert Kluin <robert.kl...@gmail.com> wrote: > > Hey Edward, > > First, you should probably star issue 2740. Space used by indexes > > is *not* included in your datastore statistics. > > http://code.google.com/p/googleappengine/issues/detail?id=2740 > > > > Every property name is stored in every entity. So if you use long > > descriptive property names you'll have lots of metadata. The property > > names are also stored in your indexes, which can really multiply your > > data! So the difference between your stored data on the quota page > > and the size of all entities in the statistics, less your blobstore > > and stored tasks, is probably pretty close to the size of your > > indexes. If we could see stats on our indexes we'd know for sure > > though, so star 2740. > > > > You can reduce the space by explicitly disabling indexes on any > > fields you're not querying or ordering by. You'll have to reput all > > of your data to reclaim the space already used. > > > > Also, don't forget, stored tasks also count against the stored data > quota. > > > > Robert > > > > On Fri, May 6, 2011 at 08:44, Edward Hartwell Goose <ed.go...@gmail.com> > wrote: > > > > > > > > > > > > > > > > > I've partially answered my own question: > > > "The "Metadata" property type represents space consumed by storing > > > properties inside an entry that is not used by the properties > directly." > > > But I don't quite follow what this means? > > > The entity that has the most meta data consists of several booleans, > between > > > 2 and 3 keys, a list of up to 60 Strings and an accompanying list of up > to > > > 13 Strings, and it is a child of a parent entity. > > > What does the above statement mean in this context? > > > > > -- > > > 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. > > -- > 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. > > -- 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.