Hi. I have the same issue. >From statistic : Last updated Total number of entities Size of all entities 3:56:43 ago 140,994 260 MBytes But in quote: Total Stored Data 96% 0.96 of 1.00 GBytes
In cron I move data (with deletion) from table with text fields, sorted by key (no special and witout indexes) to 4 tables with smollest size of the data. Source table: Total Number of Mail Entities: Average Size of Entity: 436 411 KBytes Property Type Size body Text 175 MBytes (100% of the entity) date String 21 KBytes (0% of the entity) sender String 20 KBytes (0% of the entity) subject String 15 KBytes (0% of the entity) added_on Date/Time 11 KBytes (0% of the entity) Metadata 26 KBytes (0% of the entity) Result tables: Total Number of MarketHistoryBuy Entities: Average Size of Entity: 34,578 699 Bytes Total Number of MarketHistorySell Entities: Average Size of Entity: 43,494 706 Bytes Total Number of MarketStatsBuy Entities: Average Size of Entity: 27,028 543 Bytes Total Number of MarketStatsSell Entities: Average Size of Entity: 35,205 549 Bytes inserted and searched by key Total indexes: Entity and Indexes Status MarketStatsBuy solarSystemID ▲ , typeID ▲ Serving typeID ▲ , solarSystemID ▲ Serving MarketStatsSell solarSystemID ▲ , typeID ▲ Serving typeID ▲ , solarSystemID ▲ Serving (I've deleted all other indexes hour or two earlyer. Data amount in statistic decreased day to day, but in quote - increased. On 16 дек, 14:15, "Nick Johnson (Google)" <[email protected]> wrote: > Hi bsb, > > - Each entity has a key that needs to be stored in various places. The key > consists of your App ID, kind name, and name or ID, along with the usual > Protocol Buffer overhead. > - Each field is stored in the Protocol Buffer as a key, value pair. The > total size for this is roughly len(key) + len(data) + 10 bytes (this last > quantity can vary depending on the type and size of the property). > - The automatic indexes also take up space. For each indexed field, they > need roughly the length described above, plus the length of the App ID, plus > the key for the entity. There are automatic indexes for single properties in > ascending and descending order. > > Between the various fields that need to be stored and indexed, the size of > an entity and all its indexes can easily reach 1KB, which fits your 1GB > figure for a million of them. > > -Nick > > > > > > On Wed, Dec 16, 2009 at 11:53 AM, bsb <[email protected]> wrote: > > I know this is an old story, but I still don't get it: I have ~1M > > entities, each one consists of a date, a reference and 2 ints. I have > > no custom indices or anything. The datastore statistics say that I'm > > using 188MB for the entities. The quota view tells me I'm using a > > whooping 1GB of disk space. How the *** does that work? > > > -- > > > 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. > > -- > 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]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
