Hi all,
I'm seeing from the logs that my query is taking 400ms up to around
1000ms. My model looks like:
class Track2(db.Model):
name = db.StringProperty(required=True)
date = db.StringProperty(required=True)
max_speed = db.StringProperty(required=True)
owner = db.UserProperty(required=True)
latitudes = db.ListProperty(float, indexed=False)
longitudes = db.ListProperty(float, indexed=False)
altitudes = db.ListProperty(float, indexed=False)
heart_rates = db.ListProperty(int, indexed=False)
speeds = db.ListProperty(float, indexed=False)
Each of the lists has just under 1500 entries (I only have 1 row at
the moment)
You can see an example of what I do with this here:
http://mytrackviewer.appspot.com/trackView/ag1teXRyYWNrdmlld2Vycg0LEgZUcmFjazIYnjQM
(I know, there are other places to put track data, I don't care, I'm
mostly just learning at this point)
My fetch code looks like:
track_data = db.get(track_id)
if track_data and ( len(track_data.latitudes) == len
(track_data.longitudes) ):
logging.debug('fetched track data with %d lat/longs' % len
(track_data.latitudes))
# blah blah blah, writes out stuff to generate the map from here.
This log entry here though happens after ~750ms from the request log
entry.
So my question is this: Is there some way to speed this up?
I also tried splitting the Track common stuff from the Trackpoints,
and keeping all of the points in a separate table. That was a little
slower, so I'm guessing pulling 1 really big row with all the data is
faster than pulling 1500 individual rows, is that correct?
Anything else I can try to speed up the query? would turning off the
validator help? I'm not sure what else to try.
ok thanks
-John
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
