web2py executes all commands always within a transaction. Il giorno lunedì 20 maggio 2013 15:04:23 UTC+2, Paolo valleri ha scritto: > > At least with sqlite wrapping a list of insert by adding respectively at > the beginning and at the end > BEGIN TRANSACTION/END TRANSACTION > allows to speed up the performance, see: > http://stackoverflow.com/questions/1711631/how-do-i-improve-the-performance-of-sqlite > could we do something like that in our bulk_insert? > > Paolo > > On Monday, May 20, 2013 2:57:30 PM UTC+2, Niphlod wrote: >> >> this is the implementation >> >> def bulk_insert(self, table, items): >> return [self.insert(table,item) for item in items] >> >> no limits there, but it doesn't leverage any native BULK operation, so, >> don't pass a list of 1 zillion dicts. >> >>
-- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
