Hi all,
I would like to update the database and there are two ways to do it and I were
wondering which way is better:
1) Way 1 - used the sqlite3_preare, sqlite3_bind , sqlite3_step ...
q = "UPDATE logTable SET stale = ? WHERE id = ?";
rc = sqlite3_prepare(updateSqli q, -1, &pstmt, 0);
if (rc != SQLITE_OK) {
fprintf(stderr, "Error prepare: %s\n", __FUNCTION__);
return -1;
}
ret = sqlite3_bind_int(pstmt, 1, 0);
ret = sqlite3_bind_int64(pstmt, 2, rpid);
rc = sqlite3_step(pstmt);
rc = sqlite3_reset(pstmt);
rc = sqlite3_finalize(pstmt);
2) Way #2
q = "UPDATE logTable SET stale = 1 WHERE id = ";
sprintf(sqlStmt,"%s%d ",q,rpid);
sqlSt = sqlite3_exec(pDb, sqlStmt, NULL, 0, &errMsg) ;
if (sqlSt != SQLITE_OK ) {
// print out error message
sqlite3_free(errMsg);
}
...
Which way is better in term of performance.
Thanks
JP
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
