aliquote

< a quantity that can be divided into another a whole number of time />

August 16, 2022

SQLite works with hundreds of millions of records just fine. Regular INSERTs show about 240K records per second on my laptop. And if you connect the CSV file as a virtual table (there is an extension for that) - inserts become 2 times faster. — SQLite is not a toy database