On 3/20/2013 8:29 AM, Frank Chang wrote:
Good morning,
What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON
CONFLICT IGNORE?
In *Test #1*, we have a
CREATE TABLE TESTMARY(
VALUE CHAR(40),NUMERICVALUE FLOAT, DATETIMEVALUE CHAR(40), COUNT INT,
LENGTH INT)
and a
CREATE
Good morning,
What is the reason for SQLITE UPSERT performance improvment with UNIQUE ON
CONFLICT IGNORE?
In *Test #1*, we have a
CREATE TABLE TESTMARY(
VALUE CHAR(40),NUMERICVALUE FLOAT, DATETIMEVALUE CHAR(40), COUNT INT,
LENGTH INT)
and a
CREATE UNIQUE INDEX IX_MARY ON TESTMARY(VALUE). In
2 matches
Mail list logo