> On Mar 28, 2018, at 5:34 AM, rene <[email protected]> wrote: > > But people here have decided to use json. And I'm stuck with it. > > I was only trying to get faster then the already used C++ parser. One way > was to use sqlite's json parser.
That's not going to help. Inserting the JSON into a SQL database, and then using SQL to query the database and parse the JSON it finds there, is never going to be as fast as simply parsing the JSON directly. If you want your operation to run as fast as possible, use a C/C++ JSON parser and avoid allocating memory. I've done a lot of JSON work over the years, and I find that what takes most of the time isn't the actual parsing, it's building an object tree in memory of the parsed data. So try to avoid that; in HTML terminology, use a SAX (streaming) parser instead of a DOM parser. —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
