Do you just pass the compiled statement back to the step function again? -----Original Message----- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: Thursday, January 26, 2006 2:34 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Re: Difference between finalize and reset.
nbiggs said: > What would be a good example of reusing the statement? Why not just > execute the SQL again? Using reset saves the expense of parsing the SQL statement again. For most desktop apps this isn't especially important, since the program will just spend its time waiting for user input anyway. It's very valuable in a transaction processing situation though, where the same query will be used many times. Clay Dowling -- Simple Content Management http://www.ceamus.com
