3 ms·
Building a highly-available search engine using SQLite
- otoolep 3y agorqlite creator here, happy to answer any questions.
- lnkdinsuxs 3y ago> I achieved indexing rates greater than 3,000 log lines per second, indexing 5 million logs in under 30 minutes What was the size of the 5 million logs on disk? > SELECT * FROM logs WHERE entry MATCH 'SuperSecretAgent' If I wanted to sort the results in descending order of how many times 'SuperSecretAgent' occured in the record, how would I do it?