On Jun 18, 2009, at 9:50 PM, Shaun Seckman (Firaxis) wrote: > Hello everyone, > > I'm in the process of writing some C++ wrappers to > SQLite in order to shoehorn it into some legacy code. I'm curious if > there is any performance impact to having several prepared statements > active at any given time. I was thinking about using a prepared > statement per instance of a Query class.
> Also, what is the lifetime of > the text received by sqlite3_column_text? Buffer is generally valid until the next call to sqlite3_step(), sqlite3_reset() or sqlite3_finalize() on the statement handle. You can also invalidate it by calling sqlite3_column_text16(), or bytes16(). In this case the buffer that contains the utf-8 representation (a pointer to which is returned by sqlite3_column_text()) is discarded to make room for the utf-16 representation of the same text. Dan. > -Shaun > > > > Shaun Seckman > > Firaxis Games > Programmer > > > > _______________________________________________ > 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
