Most likely indexes -- "app engine maintains an index for every query the app engine will perform" (from Programming Google App Engine)
If you have a variety of queries that use multiple properties and sort orders, the datastore will need an index for every unique combination -- and this is in addition to the indexes already created on every key and property for a "kind". Sort order is significant too -- you may need an index in ASC and DESC order for a property. Another thing to look out for: using more than one multi-valued property in an entity. Your index on those properties basically becomes the cross product of the values stored, which can make it huge. If you don't have it, the book "Programming Google App Engine" has the best treatment I've seen of the datastore. Thanks, Todd Dombrowski pzlbox On Tue, Feb 2, 2010 at 5:50 AM, Jorge <[email protected]> wrote: > Hi Dimitar, > > This is an idea. Take a closer look to your _ah_SESSION kind. It is > possible you are storing huge session data and it remains there after > the sessions expire. If that is the case, you probably want to clean > your expired sessions periodically. > > Jorge Gonzalez > > > On Feb 1, 1:05 pm, dmakariev <[email protected]> wrote: > > Hi again, > > > > I've read the documentation. and cannot find anything related to my > > datastore growth :(, > > I'm not using indexes. It is quite simple application, demonstrating > > the usage of JSF 2. I'm using session, and I've included the > > SessionCleanupServlet in my web.xml. It is started every hour. > > So the number of entities in _ah_SESSION is round 40 . > > > > My other suspect was the log file. I couldn't find any description > > about where the log files are stored. > > But I've updated the version number of the application.. deleted the > > old one with the big log files, and still the total used datastore > > quota didn't decrease. > > > > my current status is 35% of Total Stored Data > > and at the same time : Size of all entities 414 KBytes > > > > I'll be really happy to know where and how to manage properly the > > datastore space. > > > > Best Regards: > > Dimitar Makariev > > > > On Feb 1, 1:38 am, John Patterson <[email protected]> wrote: > > > > > On the page that shows those details is a link to a doc that explains > > > where the extra space is used. Probably indexes could consume a lot. > > > > > On 1 Feb 2010, at 16:29, dmakariev wrote: > > > > > > Hi all, > > > > I have the following problem : > > > > my quotas show the following : > > > > Total Stored Data 26% 0.26 of 1.00 GBytes Okay > > > > at the same time > > > > Datastore Statistics is showing : > > > > Size of all entities: 5 MBytes > > > > > > Breakdown by Property Type > > > > Property Type Size > > > > Blob 5 MBytes > > > > String 14 KBytes > > > > Integer 12 KBytes > > > > Date/Time 4 KBytes > > > > User 51 Bytes > > > > NULL 24 Bytes > > > > Metadata 71 KBytes > > > > > > And I have no idea where is the datastore space disappearing.. > > > > > > my app id is "sandcode" > > > > > > Does anybody has idea ? I'll appreciate your advices.. > > > > > > Best Regards: > > > > Dimitar Makariev > > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups "Google App Engine for Java" group. > > > > To post to this group, send email to > [email protected] > > > > . > > > > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > > > > . > > > > For more options, visit this group athttp:// > groups.google.com/group/google-appengine-java?hl=en > > > > . > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" 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-java?hl=en.
