Re: [sqlite] Performance gain in SQLite

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

Re: [sqlite] Performance gain in SQLite

Hello PP> Will I get any performance benefits if I directly generate the Vdbe PP> program instead of generating the sql string ? I think any (tiny) performance gains will be offset by the extra work required to create the VDBE program and to keep your code up to date with SQLite. SQL (the

[sqlite] Performance gain in SQLite

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