Hello, Thank you for the suggestions so far. My main goal is currently to reduce the startup time.
I have done some tests and compared the results to a pure C++ parser (nlohmann::json). 1. parsing time is nearly the same between "nlohmann::json::parse(..)" and "insert into data values(json(..))" 2. Creation of indexes is more then parsing time in both C++ and sqlite. May be this can be improved in sqlite. I have for each array an sqlite table created (arraname) and filled with: insert into arrayname select key,json_extract(value,'$.name'),json_extract(value,'$.id') from data, json_each(data.json,'$.arrayname') Necessary indexes are created after the insert statement. The database is ":memory:" and all commands are inside an transaction. Are there other options/improvements possible? Thank you Rene -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
