Ok thanks for the explanation, makes sense,

Mark

On Jul 25, 11:15 am, Geoffrey Spear <[email protected]> wrote:
> The values quoted are for all entities of the kind you're examining;
> the top of the screen will show how many entities there are and the
> average size.  I believe it will be typical for metadata to be larger
> than the data in those cases where the data is extremely tiny.  Add a
> few moderately-large strings to any model and the metadata % will
> shrink to something barely noticeable in no time.
>
> There are certainly cloud services that use relational databases.
> However, disk space is very cheap, and with services like EC2 you'll
> probably end up paying orders of magnitude more to have the mysql
> server running 24/7 than you'd pay for stored metadata on App Engine.
>
> On Jul 25, 9:58 am, Mark <[email protected]> wrote:
>
>
>
> > Hi,
>
> > I'm looking at my datastore statistics, looks like my entity
> > attributes are always smaller in size than their associated metadata.
> > For example, datastore viewer shows this for an entity of mine
> > (property names are shortened to reduce size required per entity):
>
> >    Storage Space by Property Type
> >      d   String  90 Bytes (9% of the entity)
> >      ts  Integer         75 Bytes (8% of the entity)
> >      tl  String  75 Bytes (8% of the entity)
> >      u   String  75 Bytes (8% of the entity)
> >      pr  Integer         50 Bytes (5% of the entity)
> >      Metadata      588 Bytes (62% of the entity)
>
> > I had arranged my entities in such a way as to keep them as small as
> > possible, but it looks like the size required by the metadata per
> > entity is just negating all my efforts. I understand app engine has to
> > serialize all the info about the entity, but I thought this would be
> > something more like a matter of a few bytes:
>
> >     [attribute_name + length]   per attribute
>
> > I'm worried all my disk quota is going to get eaten up fast. Does the
> > above look typical, and if it does, what are methods to reduce the
> > metadata size?
>
> > Besides that, the Integer attributes above are plain old 'int' types,
> > not 'Integer', but they still require 75 bytes each?
>
> > Are there any platforms like app engine that offer a datastore with
> > schemas so that all the entity info doesn't need to be serialized with
> > the entity?
>
> > Thanks

-- 
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.

Reply via email to