On 25 Feb 2015, at 10:21am, Sairam Gaddam <gaddamsairam at gmail.com> wrote:
> Yaa we work together and we need some assistance regarding that. See our responses to Prakash Premkumar. The things he thought he could optimize turned out to be unhelpful. You will find that just using normal SQLite calls you get acceptable performance. Nobody here is going to tell you how to hack the internal structures of SQLite. The source code from SQLite is completely public and includes plentiful comments. If you can't work out what you need to do by reading the source code, it's probably not useful to do that thing. > So what is the correct way of creating a mem object and > copying a string to its member so that SQLite will work > fruitfully. Create your own memory object using whatever tools your language gives you. Use a _bind_ function when you need SQLite to 'see' that object and a _column_ function when you need to retrieve it. <https://www.sqlite.org/c3ref/bind_blob.html> <https://www.sqlite.org/c3ref/column_blob.html> Simon.
