needs testing but please check in trunk

db.table.bulk_insert([dict(field='value'),dict(field1='value')])

Massimo

On Jan 31, 3:11 am, Jon Romero <darks...@gmail.com> wrote:
> Yeap the speadup is HUGE (one query to insert 100 rows). Inserting in
> gae is slow and if you try to insert 100 one by one you get timeout
> errors. I am using the gae_retry but insert queries are bad for
> quotas.
>
> I am already using put after importing gae but it accepts gae models
> in an array. So I have to declare AGAIN my table with gae.models and
> that creates a lot of confusion.
>
> On Jan 31, 2:31 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > We will think about this for the new DAL. It is not difficult to add.
> > Other than syntactical sugar, is there a speed up? If so for now you
> > can do
>
> > from gluon.contrib.gql import gae
>
> > gae.put(...)
>
> > and access the low lever gae api.
>
> > On Jan 30, 6:21 pm, Jon Romero <darks...@gmail.com> wrote:
>
> > > It doesn't seem that's easy to dobulkinserts for AppEngine using
> > > web2py (please correct me if I am wrong).
> > > The insert function for gae does a Table.put(data) (Model.put(data) in
> > > terms of AppEngine) where forbulkwe need:
> > > db.put([array_of_Models]).
>
> > > Is this going to be corrected on the new DAL? Is there a way to have
> > > access to db (gae) so I can do a put?
>
> > > On Jan 16, 5:08 am, Jon Romero <darks...@gmail.com> wrote:
>
> > > > Is there any way to dobulkinserts in GAE?
>
> > > > Check here number 5 (http://googleappengine.blogspot.com/2009/06/10-
> > > > things-you-probably-didnt-know-about.html)
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.

Reply via email to