I need to get the 1st and last result from a query that uses only keys (and they keys are what i need), i'm even using a cached cursor:
q = self.model.all(keys_only=True).order('__key__') # fetch/return only keys #maybe there's a better way to get the 1st/last key (taking too long) if self.job.currentCursorKey is not None: # 1st request logging.debug("\tusing last cursor: %s" % self.job.currentCursorKey) q.with_cursor(self.job.currentCursorKey) after this i'm trying two methods: A) # Fetch method users_keys = q.fetch(limit) startKey = str(users_keys[0]) endKey = str(users_keys[-1]) B) # Double query method startKey = str(q.get()) users_keys = q.fetch(limit=1, offset=limit) # get the endKey of the segment endKey = str(users_keys[0]) but both take too long (7/8 seconds at least). Should i refactor to GQL for example and do 2 SELECT's? One for the 1st and another for the 2nd? -- josemore...@irc.freenode.net http://beta.icodedhere.com http://pt.linkedin.com/in/josemoreira http://djangopeople.net/josemoreira http://www.crunchbase.com/user/josemoreira -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.