Regarding: "This would definitely work but does incur the overhead of sqlite3_prepare each time I want to run the query."
============ Maybe you would be preparing hundreds or thousands of different queries per minute -- but if by chance you're not -- could anyone be expected to notice the time for the prepare's? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users