On Mon, 6 Oct 2014 10:28:59 +0530, Prakash Premkumar <prakash.p...@gmail.com> wrote:
>Instead of generating an sql query for a select statement, I would like to >bypass the parser and fill in struct Select by myself based on the data I >have and Pass it to sqlite3Select() function. Can you please give me some >pointers in this direction ? > >I think eliminating parsing would be an optimization. Hi Prakash, Are you aware you can re-use a compiled statement? If you use placeholders instead of literals where values are expected in SQL statements, it suffices to sqlite3_bind() new values, sqlite3_step(), and finally sqlite3_reset() to use the same compiled statement again and again. That way, there is no need to _finalize() and _prepare() every time, and you may not need that optimization at all. -- Groet, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
