On 18 Oct 2009, at 4:37pm, Ron Arts wrote: > I want to skip the SQL processing entirely > and write a C function that reaches directly into the > internal memory structures to gets my record from there.
I assume that you've already tested the fastest way of doing this that the standard library allows: prebinding using _prepare, etc.. You could download the source code for SQLite, take a look at how the SELECT command is implemented, and write your own customised code which knows exactly which fields and index you want and how your table is structured. I have no idea what the results would look like or whether the developer forum would be a better place to discuss it. Start by using EXPLAIN to look at the code generated from your SELECT command. <http://www.sqlite.org/lang_explain.html> <http://www.sqlite.org/opcode.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
