Thank you for the replies. I will try to answer all of your questions.
@Kaan, yeah, wrong terms to use. But thats legacy SQL mindset in
terminology :-)
I was doing the update via a remote shell. I used the following code to
update:
for ph in phs:
ph.use_cc = True
ph.save()
The Phone kind has 12 properties. I looked into my index.yaml and there is
no index with this kind mentioned in there.
These are the stats on this particular Kind. So there were only 1616
entities I was trying to update.
EntitesBuilt-in IndexesComposite IndexesTotal Size:697 KBytes5 MBytes0
BytesEntry
count:1,61643,6420Average Size:441 Bytes127 Bytes
Any pointers would be highly appreciated. If anyone can replicate this on
their end, that would also be really helpful.
Regards,
Sarang
On Wednesday, July 4, 2012 1:51:20 AM UTC+5:30, Jeff Schnitzer wrote:
>
> Do you have some sort of loop that read forwards N entries to get to
> each value? Ie, each iteration skipped forwards N-1 to get to N.
> That would produce N^2 reads, or about 9 million.
>
> Jeff
>
> On Tue, Jul 3, 2012 at 11:53 AM, Sarang
> <[email protected]<[email protected]>>
> wrote:
> > Hello,
> >
> > I have an application that was consuming around 11 cents/day of
> datastore
> > read operations. Here is a snapshot from historical billing:
> >
> > http://gyazo.com/ee441da7686ddff4f3648383e8d7418c
> >
> > Today, I wanted to make a small change to a table with around 3000
> entries.
> > I wanted to add another bool field. So I looped over each entry, read
> each
> > row, added the boolean field, and saved. I was shocked to note that my
> app
> > went over quota and my loop stopped in between. When I looked at the
> > dashboard, it is showing me 5.8 million datastore read operations. See
> the
> > snapshot:
> >
> > http://gyazo.com/2dc918ac61c3af295378b8c1a54de77a
> >
> > This is absolutely crazy. Can anyone from the App Engine team please
> explain
> > this?
> >
> > My setup is Django non-rel. The model had only a few fields and I am not
> > doing anything special in save() method.
> >
> > Regards,
> > Sarang
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups
> > "Google App Engine" group.
> > To view this discussion on the web visit
> > https://groups.google.com/d/msg/google-appengine/-/p9YMSDN5AEAJ.
> > 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.
>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-appengine/-/bAhyhHEzC6EJ.
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.
