Hi Ankur,
The easiest way to decrease your runtime is to decrease the number of round
trips. .fetch() on a query only makes one roundtrip (instead of potentially
many in the case of iterating over it), and you can accumulate results and
put them in a single operation, like so:
---
users = db.GqlQuery("SELECT * FROM UserProfile")
updated = []
for cur_user in users.fetch(100):
up = UserProfile1()
up.user = cur_user.user
up.fname = cur_user.name
up.lname = cur_user.lname
updated.append(up)
db.put(up)
---
Several caveats, though:
- If you still have more records than can be processed in one request,
you'll need to shard this and process a bit in each request.
- Since you're not using key names or any other deduplication mechanism,
running this multiple times will create multiple sets of UserProfile1
records.
- Since all the updates aren't in a single transaction (and indeed, can't
be), your timed out attempts from earlier will have likewise created
duplicates.
You may be better considering how you can migrate your existing records
rather than creating new ones. That way, you can determine if a record has
been migrated when you retrieve it from the query, and only update it if it
hasn't.
-Nick Johnson
On Thu, Jun 4, 2009 at 8:37 AM, Ankur <stiitan...@gmail.com> wrote:
>
> hi,
>
> I am using simple code to copy my database table data to another table
>
> code used is
>
> users = db.GqlQuery("SELECT * FROM UserProfile")
>
> for cur_user in users:
> up=UserProfile1()
> up.user=cur_user.user
> up.fname=cur_user.name
> up.lname=cur_user.lname
> up.completed=bool()
> up.put()
>
> my first table has 100 records only
>
> but whenever i start back up process i always get timeout error.
>
> Any idea how can i do this...
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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-appengine@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
-~----------~----~----~----~------~----~------~--~---
