Reset count in GQL (Google App Engine)

Question

I'm having a hard time trying to reset my ID/Name column in my google app. Right now it's on 3002, yet there's only 1 other peice of data still in the DB. I'm not even certain how it decided on 300x over like 1,2,3...

I'm sure this is a simple problem for someone more SQL inclined than I am :).

Thanks in advance!

It's not that important...as you can see from the comment below, I was just curious. — farina, Aug 18 '09 at 06:09

score 1 · Accepted Answer · answered Aug 17 '09 at 12:17

1

You can't. Generated IDs are guaranteed to be unique, but not sequential or contiguous. There's no facility for resetting the ID counters.

answered Aug 17 '09 at 12:17

Nick Johnson

100,655
16
128
198

That sucks. Wonder why it jumped into the three and four thousands? – farina Aug 17 '09 at 18:47
why does it suck? how are you using the id? – Peter Recore Aug 18 '09 at 04:57
I guess it doesn't suck...I just get annoyed when things aren't in perfect order (starting with 0 or 1). Thanks again. :) – farina Aug 18 '09 at 06:09
It jumped because servers request IDs in chunks for efficiency. Sometimes a server restarts and its chunk of IDs gets discarded. – Nick Johnson Aug 18 '09 at 10:02

Reset count in GQL (Google App Engine)

1 Answers1