Hello Eric, Thank you for you explanation. It sounds kind of logical but still I am confused about the index thing.
Reading the doc carefully it tells me that indexes are created based on the queries I make. Hence if I never query an entity on a certain property there should be no index. Also in the app-engine administration there is a menu entry "Indexes" which only lists two indexes that I am actually using. Now if I understand right per default many more indexes are created if I need them or not. This should be mentioned more clearly because it could help to save a lot of space. Is there an JDO annotation to disable indexes on properties or do I need to disable auto-index? Thanks, Tobias On Dec 7, 6:00 pm, Eric Rannaud <[email protected]> wrote: > On Mon, Dec 7, 2009 at 2:20 AM, Toby <[email protected]> wrote: > > thank you for your update. In fact I was suspecting the index or other > > management data. But it is hard to believe that it leads to such a big > > overhead. I mean it is enormous to have an index that is 10 times more > > than the actual data, don't you think so? > > If you look at the article, it doesn't seem that out of place. > Remember that by default, two indexes are built for every property, > EntitiesByProperty ASC and EntitiesByProperty DESC. If you look at the > number of fields in the corresponding tables (see article), and if > your entity has 5-10 fields, I would not be surprised by such an > overhead. > > Marking properties as non-indexable, if you don't need the systematic > indexing that Google does, will help save a lot of space. > > > Furthermore in the datastorestatisticsthey already list so called > > "Metadata". It is consuming about 44% of the space. I think that this > > is the index, is it not? > > I don't think it is, no. I believe it refers to other kinds of > metadata (see article linked earlier in the thread). Index disk space > usage is, I believe, nowhere explicit. > > Eric. -- 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.
