google app engine GQL, How to do pagination with datetime with millisecond accuracy -


hi have issue on querying subsecond accuracy queries gql.. wondering if had similar issues or workarounds.

the context problem i'm loading batches of many objects google data store @ once. thousands of objects added within single second.

on retrieval, run pagination issue when i'd page based on datetime of when they're added. (the last added time ideal paging allows users data don't have.)

since batches of entities added in within sub second quantum. paging problematic if need start paging batch of entities inserted in same second.

seems app engine 1 box solution can't handle subsecond queries if try pass in datetime objects has fractions. i.e. have following query pass in datetime object fractions of second. locally i'm running python 2.6.

test = gqlquery("select * table lastupdated > :1", minimumtime)

if minimumtime 10:00:00.0500, result set still contain records lastupdated @ 10:00:00.0100, 10:00:00.0200 etc..

i'm thinking maybe workaround create own key format, needs autoincrementing. wanted see if there other simpler solutions i'm missing.

thanks, ning

don't paginate on datetime; instead, use cursors.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc...
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use...
Read more