> Perhaps the use of EXPLAIN would show the way to implement > certain types > of common accesses I expect to be done frequently, such as > inserting one > row, selecting one row using a unique key or updating one > row. Then I > could correlate the virtual machine instructions with > specific supported > API calls? Meanwhile, SQL would still work for reporting or > other types > of ad-hoc queries. Or is there a better way? Thanks.
I think you'll find that you'd have to replicate so much of what's done after the SQL is compiled that there would be little (almost nothing) saved in terms of execution time and an immense increase in complexity. If you prepare a query and execute repeatedly there really isn't any penalty to "using the SQL layer". -Tom