In this case:
-------------------------
CREATE TABLE test (
Field01 text PRIMARY KEY NOT NULL,
Field02 text
);
insert into test values ('alpha','beta');
update test set Field01='alpha', Field02='gamma';
-------------------------
In the "update" statement, i re-set the primary field "Field01" to a
value that field already have.
Sqlite detect this situation and don't update the primary index, or
suppose that developers optimize situation like that?
P.s. in our program, the "update" statement are generated from a
database-layer, and optimize the statement generation is a big work..
for that i'm trying to understand if will be a biggest optimization or
not..
thanks for feedback!
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
