I just did a test on one of my apps. Nearly all my data is in a single model.
I have 163189 instances, and the total size (calculated by reading each instance and running to_xml() on it, and then adding up the results) is 281,145,536 bytes. Most of my properties have indexed=False. The dashboard reports using 890MB of data. I don't know whether the dashboard calculation is wrong, whether I should be using a different calculation to estimate my record size, or something else. If my indexes really are consuming 600MB, then I would work on redoing a chunk of the app to fix that problem. However, the only course at the moment appears to be to delete old data, and hope that the data consumption goes down. Not really very satisfactory. Philip On May 12, 1:38 am, Andy Freeman <ana...@earthlink.net> wrote: > Since index space can be significant, can we get some additional > information? > > For example, does an indexed db.ListProperty(db.Key) with three > elements take significantly more or less space than an indexed > db.StringListProperty with three elements whose value is str() of the > same keys? (The pickle of keys seems to be significantly larger than > the pickle of the equivalent strings.) > > On May 11, 5:04 pm, "Jason (Google)" <apija...@google.com> wrote: > > > Hi Anthony. I'm very sorry for the late reply, and thank you for bearing > > with me. I've discussed this with thedatastoreteam and it's evident that > > the CSV file's size is not a great indicator of how much storage your > > entities will consume. On top of the size of the raw data, each entity has > > associated metadata, as you've already mentioned, but I'd bet that the > > indexes are consuming the greatest space. If you don't ever query on one or > > more of these 15 string properties, you may consider changing their property > > types to Text or declaring indexed=false in your model. If you can do this > > with one of your properties and re-build your indexes, I'd be interested in > > seeing how much your storageusagedecreases since you'll need one less > > index. > > > (Note that single-property indexes are present but not listed in the Admin > > Console.) > > > - Jason > > > On Sat, May 9, 2009 at 4:34 PM, Kugutsumen <kugutsu...@gmail.com> wrote: > > > > Two weeks ago, I've sent my applications ID to both you and Nick and I > > > haven't heard from you since then. > > > > Thanks- Hide quoted text - > > > - Show quoted text - > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
