> On Sep 25, 2018, at 11:14 AM, dmp <da...@dandymadeproductions.com> wrote: > > The result for the 50K file db test of SQLite was 370.184 > seconds. Is this a reasonable transfer speed, given the > conditions noted?
You haven’t specified how much of that time was spent in SQLite. For all we know, 370 seconds was spent in MariaDB and your own code, and it only took .184 sec for SQLite to insert the rows :) Try running your code with a profiler. Or at least wrap some quick & dirty timing code around your functions that call SQLite. Also, make sure to insert as many rows as possible within a transaction. Committing a transaction in SQLite is quite expensive due to filesystem flushing. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users