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)
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

Reply via email to