tags:

views:

122

answers:

1
Q: 

Reset count in GQL (Google App Engine)

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!

+1  A: 

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

Nick Johnson  2009-08-17 12:17:32
That sucks. Wonder why it jumped into the three and four thousands?
farina  2009-08-17 18:47:05
why does it suck? how are you using the id?
Peter Recore  2009-08-18 04:57:20
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  2009-08-18 06:09:02
It jumped because servers request IDs in chunks for efficiency. Sometimes a server restarts and its chunk of IDs gets discarded.
Nick Johnson  2009-08-18 10:02:27

related questions

.html() jQuery method bizzare bug -   resolves to empty space locally, but not on production.
cron jobs on google appengine
How do I get the key value of a db.ReferenceProperty without a database hit?
Is Google App Engine a worthy platform for a Lifestreaming app?
Sure Google Appengine scales, but is it also fast?
Feedback on using Google App Engine?
Delete all data for a kind in Google App Engine
How can I unit test responses from the webapp WSGI application in Google App Engine?
How to think in data stores instead of databases?
How do you access an authenticated Google App Engine service from a (non-web) python client?
Google App Engine: how can I programmatically access the properties of my Model class?
Upload files in Google App Engine
How do you design data models for Bigtable/Datastore (GAE) ?
Anyone out there using web2py?
Which python framework is best for web development in google app engine?
How can I access App Engine through a Corporate proxy?
What's a good way to find relative paths in Google App Engine?
Any good AJAX framework for Google App Engine apps?
Python: No module named core.exceptions
Project structure for Google App Engine
Google App Engine: Is it possible to do a Gql LIKE query?
How to get the correct Content-Length for a POST request.
Deleting an Google App Engine application
Django Templates and variable attributes.
Graphing JavaScript Library