thanks for the link. i'll try and take a look this weekend and see if there is a place for that in the DAL (feel free to open gluon/dal.py yourself too).
yup, i'm paying more for writes right now then i am for instance hours per day on my largest paid application. :) cfh On Thursday, February 21, 2013 5:59:06 PM UTC-8, Scott Hunter wrote: > > According to > https://developers.google.com/appengine/docs/python/datastore/indexes#Unindexed_Properties, > > "You declare a property unindexed by setting indexed=False in the property > constructor". > > One incurs the cost of a write (or 2?) for every property of a record that > gets written; so, for a table with about 25 fields (once you include all of > the ones web2py adds), inserting 300 records incurs the cost of 14K+ > writes; as the free account has a limit of 50K writes per day, that is > rather limiting. It is easy to turn such indicies back on, but you have to > re-write every record in order to repopulate them. > > - Scott > > On Thursday, February 21, 2013 4:51:59 PM UTC-5, howesc wrote: >> >> i'm being lazy here....do you have the instructions (or link to >> instructions) from GAE for disabling indexes? i don't have it handy right >> now.... >> >> we can check if the DAL has a secret way to handle it, and/or create a >> patch to allow it. >> >> may i ask what advantage you are hoping to achieve by skipping those >> indexes? i've left them on for fear of making a bad choice that i can't >> revert. >> >> christian >> >> On Thursday, February 21, 2013 5:56:07 AM UTC-8, Scott Hunter wrote: >>> >>> As I understand it, the GAE datastore will automatically create an index >>> for every field of every table (to facilitate queries using single fields); >>> those requiring multiple fields also get generated, but will get added to >>> index.yaml by the SDK when tested locally. Since these are created outside >>> of the DAL, I wouldn't expect to be able to remove them using it. I also >>> understand that there is a way, with the GAE SDK, to disable the index for >>> any given field (by a parameter in the field definition); is there any way >>> to accomplish this through the DAL, and if so, what is it? >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
