Hello Richard ! I noticed that sqlite do not use any memoization in json1 functions.
For example jsonExtractFunc and others parse the json string every time it's called even when the json string is the same.
minimal example : "select json_extract(json, '$.name') name, json_extract(json, '$.address') name from some_table;"
Could be possible to have some kind of memoization as a general option for any sqlite functions ?
Cheers ! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users