>
>
> - the number of properties and approximate size of the entities
>
They are all deleted now but were simple entities with 4 or 5 properties and
none of these properties were bigger than a few characters of Strings.. A
can say that each entity was less than 1Kb.
> - Do you have any indexes defined for these entities?
>
I didn't have and indexes on any entities.
> - Are you using key-only queries (i.e. are you calling Query.setKeysOnly())
> ?
>
I checked my code again and I noticed that I forgot to call setKeysOnly...
This is my mistake obviously, however as I said, the entities weren't so
big.
The code is something like this:
Query q = new Query("Movie");
PreparedQuery pq = datastore.prepare(q);
Iterator<Entity> iter = pq.asIterator(FetchOptions.Builder.withLimit(1000));
// iterate the iterator and store the Key objects in ArrayList<Key>
datastore.delete(listOfKeys);
Erdinc
Thanks,
> Don
>
> On Thu, Sep 17, 2009 at 3:18 PM, Ali - <[email protected]> wrote:
>
>> A correction.. 176K ms, so 176 seconds (not 17,6 seconds)..
>> I think because of parallel execution it must have been calculated so.
>> Maybe it is the calculation in a single cpu system. A single cpu machine
>> would have executed in 176 seconds.
>>
>> About being expensive.. I totally agree to you..
>>
>> aLi
>>
>> 2009/9/16 Erdinc Yilmazel <[email protected]>
>>
>> I was trying to delete all records of an entity type, 1000 entities on
>>> each request and I noticed the Google appengine headers returned from the
>>> server. The code uses the low level datastore api and it is a very basic
>>> piece of code.
>>>
>>> Query the datastore for the entity kind without any criteria.
>>> Fetch 1000 entities
>>> Store the entity keys in a List<Key>
>>> call datastore.delete(Iterable<Key>) method to delete the entities.
>>>
>>> No problem about these. But the google headers returned from the server
>>> about the resource consumption and an estimation of cost really confused
>>> me...
>>>
>>> X-Appengine-Estimated-CPM-US-Dollars: $4.089296
>>> X-Appengine-Resource-Usage: ms=332 cpu_ms=176178 api_cpu_ms=176015
>>>
>>> AFAIK the estimated dollars mean that if I make 1000 requests like this,
>>> it would cost me ~ $4. Don't you think it is a bit expensive??? I know this
>>> isn't a very common scenario, but really is it worth $4?
>>> And I don't really understand the meaning of resource header... The
>>> server returns the response immediately, as stated in the ms=332 value.. How
>>> is the cpu_ms and api_cpu_ms calculated? If the response was generated in
>>> 0.3 seconds, what does 17.6 seconds of cpu time mean?
>>>
>>> Thanks
>>>
>>> Erdinc
>>>
>>>
>>>
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
