Maybe you can face transaction size problems with this volume.
Web2py, by default, just commits after a successful transaction. So, try to db.commit() after some transaction completion identification.
But I think processing time wouldn't be your problem. -- Vinicius Assef On 08/17/2012 08:50 AM, Mike Girard wrote:
Hello: What is the prescribed method for doing large bulk inserts? I am using sqllite as my backend. Is it ok to just write a Python script that talks to the db directly or should the DAL be used? The book says the bulk_insert method is not more advantageous than a for loop. I searched this group for an answer but didn't find anything definitive. Thanks. PS Kudos to the web2py creator and contributors. Every day I am struck by how elegant, easy and well-designed it is.
--
