>>> Are you using a single prepared statement and binding values (in which case, how do you know what values to bind for the "non-updated" columns?) or are you creating query strings?
Advertising
I am not too sure, if i get it completely. My current code has a lot of update statements like. "update records set name=:name, type=:type, class=:class, ttl=:ttl where rr_id=:rr_id;" every time we do prepare the statetment again (sqlite3_prepare_v2) and call sqlite_bind_* for each of these columns (name, type, class, ttl) and then execute. Now here intent was/is to just update "ttl" column but i see that we are unnecessarily updating 4 fields. And my original question was in this context where i want to figure out whether it could make some performance improvement if we change the above statement to "update records set ttl=:ttl where rr_id=:rr_id;" -- 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
