On 2015/12/08 12:16 PM, Domingo Alvarez Duarte wrote: > If I understood correctly when no transaction is specified an implicit > transaction is created so there is no point to create a transaction for only > one statement.
Yes, but what Simon is trying to achieve is to have the transaction explicitly record to the journal so as to avoid locking the tables until the transaction concludes, which we are hoping would allow the Query engine time to realize that there needn't be a table write at all (since zero records were selected), and so commit the journal without actually locking the table. Makes sense? > Try this ... > > BEGIN > INSERT INTO t1 ... > END > > See whether the INSERT command still involves as much writing. > > Simon. >
