I upgraded from 1.9.2 to 1.9.4 and have noticed that datastore queries are taking substantially longer -- here's a comparison for loading the same page (not using NDB):
before: instance.py:385] Request handled by <Instancea05df4abeccece9cdfeec56ee573ea1627a0 : 1/8, total: 3> in 0.9100s after: instance.py:385] Request handled by <Instanceb2f99bd20bb11df4a1e2fcf0a0585b5da31a : 1/8, total: 16> in 67.9088s The generated query was made more complex in 1.9.3, which is probably partially the reason: https://code.google.com/p/googleappengine/source/diff?spec=svn427&old=410&r=427&format=unidiff&path=%2Ftrunk%2Fpython%2Fgoogle%2Fappengine%2Fdatastore%2Fdatastore_sqlite_stub.py generated query before: SELECT Entities.__path__, Entities.entity FROM "dev~application!!Entities"AS Entities INNER JOIN "dev~application!!EntitiesByProperty" AS ebp_0 ON Entities.__path__ = ebp_0.__path__ INNER JOIN "dev~application!!EntitiesByProperty" AS ebp_1 ON Entities.__path__ = ebp_1.__path__ INNER JOIN "dev~application!!EntitiesByProperty" AS ebp_2 ON Entities.__path__ = ebp_2.__path__ WHERE ebp_0.kind = :1 AND ebp_0.name = :2 AND ebp_0.value = :3 AND ebp_1.kind = :4 AND ebp_1.name = :5 AND ebp_1.value = :6 AND ebp_2.kind = :7 AND ebp_2.name = :8 ORDER BY ebp_2.value DESC, Entities.__path__ ASC generated query after: SELECT Entities.__path__, Entities.entity FROM "dev~application!!Entities"AS Entities INNER JOIN (SELECT kind, name, value, __path__ FROM "dev~application!!EntitiesByProperty" ORDER BY kind, name, value, __path__)AS ebp_0 ON Entities.__path__ = ebp_0.__path__ INNER JOIN (SELECT kind, name, value,__path__ FROM "dev~application!!EntitiesByProperty" ORDER BY kind, name, value, __path__)AS ebp_1 ON Entities.__path__ = ebp_1.__path__ INNER JOIN (SELECT kind, name, value,__path__ FROM "dev~application!!EntitiesByProperty" ORDER BY kind, name, value, __path__)AS ebp_2 ON Entities.__path__ = ebp_2.__path__ WHERE ebp_0.kind = :1 AND ebp_0.name = :2AND ebp_0 .value = :3 AND ebp_1.kind = :4 AND ebp_1.name = :5 AND ebp_1.value = :6AND ebp_2 .kind = :7 AND ebp_2.name = :8 ORDER BY ebp_2.value DESC, Entities.__path__ ASC; Was the change made in 1.9.3 really necessary? This has made developing locally unusably slow for me. > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-appengine. For more options, visit https://groups.google.com/d/optout.
