I rebind them on every iteration. On Mon, May 14, 2012 at 6:46 PM, Pavel Ivanov <paiva...@gmail.com> wrote:
> > One the data is commited surely it doesn't need to be retained, does it? > > If you called sqlite3_reset() on a statement and then didn't call > sqlite3_clear_bindings() then all bindings will surely be needed on > the next statement execution in some subsequent transaction. > > > Pavel > > > On Mon, May 14, 2012 at 11:35 AM, Black, Michael (IS) > <michael.bla...@ngc.com> wrote: > > If you do a periodic commit and use SQLITE_TRANSIENT wouldn't that work? > > > > > > > > One the data is commited surely it doesn't need to be retained, does it? > > > > > > > > Michael D. Black > > > > Senior Scientist > > > > Advanced Analytics Directorate > > > > Advanced GEOINT Solutions Operating Unit > > > > Northrop Grumman Information Systems > > > > ________________________________ > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on behalf of Baruch Burstein [bmburst...@gmail.com] > > Sent: Monday, May 14, 2012 10:20 AM > > To: General Discussion of SQLite Database > > Subject: EXT :Re: [sqlite] a couple of questions > > > > On Mon, May 14, 2012 at 5:45 PM, Richard Hipp <d...@sqlite.org> wrote: > > > >> On Mon, May 14, 2012 at 10:35 AM, Baruch Burstein <bmburst...@gmail.com > >> >wrote: > >> > >> > > >> > 2. How "static" does data have to be to be bound with SQLITE_STATIC? > If > >> it > >> > won't change until the call to sqlite3_step, is that enough? How about > >> > until sqlite3_reset or sqlite3_clear_bindings? If all of those are not > >> > enough, I assume that if it doesn't change before the > sqlite3_finalize, > >> it > >> > must be safe to use SQLITE_STATIC? > >> > > >> > >> SQLITE_STATIC means that the content must not change until after SQLite > has > >> read it for the last time. You are guaranteed to be safe if you hold > the > >> content unchanged until sqlite3_finalize(). You can probably get away > with > >> changing the content sooner than that, but it depends on your > >> circumstances. Why push your luck? > >> > > > > For speed. I will be binding - stepping (it is an update statement) - > > resetting in a tight loop, possibly up to about a million times. > > > > -- > > Programming today is a race between software engineers striving to build > > bigger and better idiot-proof programs, and the Universe trying to > produce > > bigger and better idiots. So far, the Universe is winning. - Rich Cook > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users