Task Queues are GAE specific and are often necessary because of the time restrictions for each request: http://code.google.com/appengine/docs/python/taskqueue/
On Sep 11, 2:09 am, Miguel Goncalves <[email protected]> wrote: > thanks I'll give it a try. > Are Tasks Queues part of web2py or is it something specific to GAE? > > > > > > > > On Thu, Sep 9, 2010 at 9:41 PM, Richard <[email protected]> wrote: > > I don't know a good general solution for web2py, but if just targeting > > GAE: > > 1) request all existing products > > 2) find which of your products are new > > 3) insert new products in a single operation using the GAE API: > > db.put(list_of_models) > > > And if you have timeouts then break it up with Task Queues. > > > On Sep 9, 4:37 pm, Miguel <[email protected]> wrote: > > > Hi > > > > I have the following table: > > > db.define_table("products", > > > Field("categoryID", db.productCategory, writable=False, > > > readable=False, requires=IS_IN_DB(db, "productCategory.id", > > > "productCategory.name") ), # reference field > > > Field("productName", 'string',length=512, default=None), > > > Field("description", 'text',default=None) > > > ) > > > > - I have a list of (20000) rows that might contain products and I > > > would like to update my table. However some products might already be > > > in the db while others are completely new. > > > - I want to insert a row if it does not exist in the db (productName > > > could play the role of the identifier here) is already there AND > > > update a row in the case the product already exists in the DB> > > > > I can do it pretty easily if I go item by item and check if it already > > > exits in the db and then take the appropriate action (insert or > > > update). What I am looking for is the most efficient way to do this > > > (especially on GAE). > > > > thanks > > > Miguel
