Olaf Beckman Lapré wrote:
Hi,
I assume that the sqlite3_prepare() / sqlite3_bind() combination results in
faster performance than sqlite3_exec() for INSERT and UPDATE statements. But
where can I find example code that uses prepare/bind? Googling didn't give any
results.
Greetz,
Olaf
Olaf,
You could look at the source code for sqlite3_exec() in legacy.c at . It
is implemented using sqlite3_prepare() and friends. The
sqlite3_prepare() API functions are also used to implement many features
of the sqlite shell. You can search for sqlite3_prepare in the file
shell.c. The source files can be viewed at
http://www.sqlite.org/cvstrac/dir?d=sqlite/src.
HTH
Dennis Cote