I recall there is or once was a way to compile sqlite so that you could embed in your program the pre-generated sql. This was for embedded programs, not to speed things up, but to remove the parser and save memory in very small embedded systems. For it to work, the sql and the database schema couldn't change.
I haven't heard this mentioned in a very long time, so I don't know that it is still supported anymore. But it might be worth your searching the sqlite web site, or the user list from a few years back. David On 10/06/2014 07:50 AM, Prakash Premkumar wrote: > Will I get any performance benefits if I directly generate the Vdbe program > instead of generating the sql string ? > > My application emits out sql strings for execution. Instead if I generate > the Vdbe program myself , will I get performance benefits since, I am > bypassing the parser. > > Thanks > Prakash > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
