Re: [sqlite] Is sqlite3 smart enough to remove redundant command?

2020-01-29 Thread David Raymond
g list Subject: [sqlite] Is sqlite3 smart enough to remove redundant command? Suppose that I have the following command, which writes two entries with the same key. So the 1st entry will be overwritten by the 2nd entry. Therefore, there is no need to write the 1st entry. Is sqlite3 smart enough to n

Re: [sqlite] Is sqlite3 smart enough to remove redundant command?

2020-01-28 Thread Igor Tandetnik
On 1/29/2020 12:04 AM, Peng Yu wrote: Suppose that I have the following command, which writes two entries with the same key. So the 1st entry will be overwritten by the 2nd entry. Therefore, there is no need to write the 1st entry. Is sqlite3 smart enough to not to write the 1st entry? Or it will

[sqlite] Is sqlite3 smart enough to remove redundant command?

2020-01-28 Thread Peng Yu
Suppose that I have the following command, which writes two entries with the same key. So the 1st entry will be overwritten by the 2nd entry. Therefore, there is no need to write the 1st entry. Is sqlite3 smart enough to not to write the 1st entry? Or it will write both the 1st entry and the 2nd en