You're kind of asking if a 4 cylinder engine can outrun an 8 cylinder engine by just physically looking at the engines. The answer is yes. It can. Given the right circumstances.
Your transfer rates are going to be subjective based on your hardware, network speeds at the source and destination (I know, LAN, but still relevant), plus what kind of transactions you're doing per-insert on your SQLite database, indexing on the database, and such. If you DON'T wrap your insert/update/delete statements in a transaction, then by SQLite will open a transaction, write your one row, then close the transaction, and do that for every single row you're adding/deleting/updating. Just writing this particular email, I've been bouncing back and forth between "Yeah, that's fine" and "Well, maybe not..." because there's a LOT of things in the way that we're not clear on. Especially the transactions aspect. On Tue, Sep 25, 2018 at 2:14 PM, dmp <da...@dandymadeproductions.com> wrote: > Hello, > > I have created a database to database transfer plugin for > my application. The plugin is functional and I have > collected a log of testing results stored in a SQLite db. > The links below are of the database and definition of > parameters fields. The main exception, dbTypeMemory, > meaning memory or file db. > > https://github.com/danap/db_to_filememorydb/blob/master/ > docs/dblog/db_To_db_Parameters-log.db > https://github.com/danap/db_to_filememorydb/blob/master/lib/plugins/DB_To_ > FileMemoryDB/transfer-param.config > > Testing was done with a 50K entry MariaDB table on a low > end local network machine. Four fields in the table, Integer, > Double, Text, and Blob. Text and Blob fields of arbitrary > length to 10K. > > Resulting file database sizes for all 50K rows were in the > range of 390MB to 1.83GB. > > The application is Java based and uses JDBCs. > > The result for the 50K file db test of SQLite was 370.184 > seconds. Is this a reasonable transfer speed, given the > conditions noted? > > danap. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
