Comment on SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/sparentComments−pstuart3yWere those individual inserts or as a transaction? The latter should significantly bump those numbers up. Also consider doing a prepared statement while you're at it.−MaksadbekOP3yI assume it were individial inserts. https://docs.python.org/3/library/sqlite3.html#sqlite3.Curso...
Comments
Were those individual inserts or as a transaction? The latter should significantly bump those numbers up. Also consider doing a prepared statement while you're at it.
I assume it were individial inserts. https://docs.python.org/3/library/sqlite3.html#sqlite3.Curso...