I have model:
class Artist1(db.Model):
album_id = db.IntegerProperty()
artist_id = db.IntegerProperty()
genre_id = db.IntegerProperty()
name = db.StringProperty()
price = db.FloatProperty()
year = db.IntegerProperty()
Simple code for fetching:
def get(self):
num = int(self.request.get('num'))
key = str(self.request.get('key'))
if (key == "k"):
q = db.GqlQuery('select * from Artist1')
if (key == "a"):
q = db.GqlQuery('select __key__ from Artist1')
r = q.fetch(num)
I have abnormal cpu results in admin logs: (a=query all, k=query key;
10,50,etc=fetch limit)
a10
973ms 97cpu_ms 30api_cpu_ms
684ms 99cpu_ms 30api_cpu_ms
569ms 60cpu_ms 30api_cpu_ms
k10
325ms 240cpu_ms 150api_cpu_ms
278ms 282cpu_ms 150api_cpu_ms
434ms 175cpu_ms 150api_cpu_ms
a50
615ms 163cpu_ms 78api_cpu_ms
810ms 177cpu_ms 78api_cpu_ms
672ms 100cpu_ms 78api_cpu_ms
k50
678ms 778cpu_ms 678api_cpu_ms
592ms 764cpu_ms 678api_cpu_ms
543ms 757cpu_ms 678api_cpu_ms
a100
344ms 188cpu_ms 138api_cpu_ms
415ms 184cpu_ms 138api_cpu_ms
537ms 163cpu_ms 138api_cpu_ms
k100
370ms 1496cpu_ms 1338api_cpu_ms
298ms 1496cpu_ms 1338api_cpu_ms
392ms 1470cpu_ms 1338api_cpu_ms
a250
314ms 385cpu_ms 318api_cpu_ms
661ms 382cpu_ms 318api_cpu_ms
281ms 376cpu_ms 318api_cpu_ms
k250
967ms 3872cpu_ms 3318api_cpu_ms
751ms 3714cpu_ms 3318api_cpu_ms
819ms 3687cpu_ms 3318api_cpu_ms
Question: why "select __key__" costs in 5-10 times more, than "select
*" and can we expect that this "fix", cos i suppose opposite situation
(less time for query then more)?
My AppID: fetch0
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" 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?hl=en
-~----------~----~----~----~------~----~------~--~---
