Re: [sqlite] Is mutliple-execute-one-commit slower than multiple single-execute-single-commit?

2020-01-29 Thread Richard Damon
On 1/29/20 1:42 AM, Peng Yu wrote: 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

Re: [sqlite] Is mutliple-execute-one-commit slower than multiple single-execute-single-commit?

2020-01-29 Thread Keith Medcalf
On Tuesday, 28 January, 2020 23:42, Peng Yu wrote: >I have two python programs using sqlite3. They function the same, >except the following. I presume this means you are using the standard (as in included with the standard Python distribution) sqlite3 module? There are other ways to use

[sqlite] Is mutliple-execute-one-commit slower than multiple single-execute-single-commit?

2020-01-28 Thread Peng Yu
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