Hi, I have two python programs using sqlite3. They function the same, except the following.
In the first, execute() is called in batches and then commit() is called following them. In the second, commit() is called after each execute(). It seems that the second case is faster (I can not separate my code in a self-contained test case to show here). This is counterintuitive. I thought the first should be faster. Is it expected that the 2nd case should be slightly faster? -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
