On Mon, Jun 16, 2008 at 06:07:46AM -0500, John Stanton scratched on the wall: > You are expecting a miracle to ask for help without being allowed to > report the problem. > > Sqlite3_exec just encapsulates prepare and step. If your code runs > slower you have a logic error somewhere.
....unless your queries involve lots of strings or blobs, and you're using the SQLITE_TRANSIENT flag for sqlite3_bind_text|blob*(). In that case, the prepare-bind-step cycle can be slower, even if you're properly preparing each statement only once. If that's the case, try to structure your code to use SQLITE_STATIC memory management of the bind params. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
