RE: [web2py] Re: bulk_insert

2011-12-15 Thread Mark Breedveld
I am planning on implementing mongodb bulk inserts. They should be a bit faster. Van: web2py@googlegroups.com [mailto:web2py@googlegroups.com] Namens nick name Verzonden: donderdag 15 december 2011 23:11 Aan: web2py@googlegroups.com Onderwerp: [web2py] Re: bulk_insert bulk insert is not

[web2py] Re: bulk_insert

2011-12-15 Thread nick name
bulk insert is not really bulk except on GAE, although it might potentially be in the future. The non GAE implementation at this point is: def bulk_insert(self, table, items): return [self.insert(table,item) for item in items] No database seems to override it.

[web2py] Re: bulk_insert

2011-12-15 Thread lyn2py
Thank you Johann, you got me thinking! So if I have a bunch of records and some are existing in the tables already, I would have to go through each of them to perform a update_or_insert. Am I wrong to say that this method is resource intensive? Is there a way to ease the db load? (And I understan