Gwendolynn ferch Elydyr wrote:
I seem to recall that there was a significant performance difference between using sqlite3_exec vs prepared statements. You might try
using sqlite3_prepare/bind/finalize.
I would add that you need to do all of your database retreiving before starting the updating. Misreading this advice, it would sound like Gwnedolynn was advising you to intermix them. Although that's certainly not the case, I made that mistake on my first reading.
Prepared statement should save you a lot of time here. This is precisely the situation for which they excel.
Clay
