Re:SQLite as a Document Database
by h3rald on Friday November 27, 2020 @09:18PM
(#25234585)
Not published unfortunately but I should, really!
In the past I tested importing dumps of the full HTML and CSS documentation docset from MDN and:
- Importing files in a directory is relatively fast: I import batches and it can import hundreds of pages in a few seconds
- sadly there's no bulk operation yet to insert arbitrary json documents (unless they are stored as files in a folder), so that's quite slow.
- full text search and querying indexed (JSON) properties is fast (double-digit milliseconds for searching several hundred of relatively large documents with paged results)
I do need to do some compared benchmarks with similar data stores though.
In the past I tested importing dumps of the full HTML and CSS documentation docset from MDN and: - Importing files in a directory is relatively fast: I import batches and it can import hundreds of pages in a few seconds - sadly there's no bulk operation yet to insert arbitrary json documents (unless they are stored as files in a folder), so that's quite slow. - full text search and querying indexed (JSON) properties is fast (double-digit milliseconds for searching several hundred of relatively large documents with paged results)
I do need to do some compared benchmarks with similar data stores though.