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.
Advertising
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
