Re: [sqlite] Performance impact of UPDATEing multiple columns vs few columns

[Clemens Ladisch]

ghalwasi wrote:
> what will be the difference (in context of CPU cycles & performance)
> if i UPDATE multiple columns or only few columns.

SQLite always rewrites the entire row, so there is no practical
difference.


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Performance impact of UPDATEing multiple columns vs few columns

[ghalwasi]

I am using SQLite C library in my application and I have a question regarding
updating "mutiple" columns using UPDATE statement.
Lets suppose, my Database table has 10 columns (c1, c2 ... c10). My question
is that what will be the difference (in context of CPU cycles & performance)
if i UPDATE multiple columns or only few columns.

Lets say if the requirement is to just update c2 & c3 but if we are updating
c2, c3,c4,c5,c6,c7

UPDATE db SET c2,c3,c4,c5,c6,c7 WHERE c1=x (c1 is a primary key)
or 
UPDATE db SET c2,c3 WHERE c1=x (c1 is a primary key)




--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users