I like Philip's suggestion a lot. It will help us all identify space intensive indexes, and _hopefully_ reduce the number of posts about this.
I submitted a feature request for this issue: http://code.google.com/p/googleappengine/issues/detail?id=2740 Robert On Mon, Feb 8, 2010 at 2:27 PM, WeatherPhilip <[email protected]> wrote: > This issue comes up about once per week. Google -- you need to address > this. The simplest way of addressing it would be to put the size of > *every* index on the statistics page, and show that the total > corresponds (roughly) to the quota number. > > This would enable people to see which index (or indexes) was consuming > a lot of space, and take steps to optimize -- maybe by not indexing > that field. > > Philip > > On Feb 8, 1:48 pm, "Ikai L (Google)" <[email protected]> wrote: >> Are you storing information in sessions? Session information can also take >> up space. >> >> >> >> >> >> On Mon, Feb 8, 2010 at 5:32 AM, Pavel Kaplin <[email protected]> wrote: >> > Here's the detailed description of mentioned indexes: >> > 1) address (string, < 100 bytes), tradePoint(String, < 100 bytes), >> > user (Key, generated by GAE), timestamp >> > 2) tradePoint, user, timestamp >> > 3) user, timestamp >> >> > Entities count is about 15k. I don't understand how it might happened. >> >> > On Feb 8, 3:25 pm, "Nick Johnson (Google)" <[email protected]> >> > wrote: >> > > Hi Pavel, >> >> > > That depends on the nature of your indexes, and the entities being >> > indexed. >> > > It's certainly possible for indexes to reach this magnitude - >> > particularly >> > > if you're indexing list properties. >> >> > > -Nick Johnson >> >> > > On Mon, Feb 8, 2010 at 1:12 PM, Pavel Kaplin <[email protected]> >> > wrote: >> > > > It's hard to believe that 3 indexes (for 2, 3 and 4 fields) could eat >> > > > 9x more space than data itself. >> >> > > > On Feb 8, 2:45 pm, "Nick Johnson (Google)" <[email protected]> >> > > > wrote: >> > > > > Hi Pavel, >> >> > > > > The datastore stats include only the raw size of the entities. The >> > total >> > > > > space consumed is the space consumed by the entities, plus the space >> > > > > consumed by all your indexes. >> >> > > > > -Nick Johnson >> >> > > > > On Mon, Feb 8, 2010 at 12:35 PM, Pavel Kaplin < >> > [email protected] >> > > > >wrote: >> >> > > > > > Hi there! >> >> > > > > > My datastore stats says me "Size of all entities = 51 MBytes", but >> > > > > > dashboard shows 0.54 Gb as Total Stored Data. >> >> > > > > > As you can see, these values differ from each other for more than >> > ten >> > > > > > times. Why? >> >> > > > > > Application id is bayadera-tracker >> >> > > > > > -- >> > > > > > 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]<google-appengine%2Bunsubscrib >> > > > > > [email protected]><google-appengine%2Bunsubscrib >> > [email protected]><google-appengine%2Bunsubscrib >> > > > [email protected]> >> > > > > > . >> > > > > > For more options, visit this group at >> > > > > >http://groups.google.com/group/google-appengine?hl=en. >> >> > > > > -- >> > > > > Nick Johnson, Developer Programs Engineer, App Engine >> > > > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration >> > > > Number: >> > > > > 368047 >> >> > > > -- >> > > > 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]<google-appengine%2Bunsubscrib >> > > > [email protected]><google-appengine%2Bunsubscrib >> > [email protected]> >> > > > . >> > > > For more options, visit this group at >> > > >http://groups.google.com/group/google-appengine?hl=en. >> >> > > -- >> > > Nick Johnson, Developer Programs Engineer, App Engine >> > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration >> > Number: >> > > 368047 >> >> > -- >> > 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]<google-appengine%2Bunsubscrib >> > [email protected]> >> > . >> > For more options, visit this group at >> >http://groups.google.com/group/google-appengine?hl=en. >> >> -- >> Ikai Lan >> Developer Programs Engineer, Google App >> Enginehttp://googleappengine.blogspot.com|http://twitter.com/app_engine > > -- > 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. > > -- 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.
