Thanks, Richard

I found (https://www.sqlite.org/docsrc/timeline) &
https://www.sqlite.org/docsrc/artifact/5c48dd261dbe5804  very useful.

Last year I was parsing 100M of XML stuff and loading it into an Sqlite
database. A bit of hammering required as the XML had minor errors like
missing end tags. "malformed" 


In a meeting, we were discussing a very specific piece of functionality.
"How many times is this function used?" One guy said "About 300 times"
by I was able to answer 2365 times, within 30 seconds, just some simple
SQL.

Incidentally, it was far easier to regenerate the XML from the Sqlite,
similar to a comma delimited format, without all the "malformed"
problems. 

The malformed XML was targeted to be stored in Git. 


regs,

Kev



Reply via email to