On Tue, Sep 25, 2018 at 8:41 PM 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? > As Stephen already wrote, impossible to say. Start by contrasting this DB-copy you wrote to other methods: 1) filesystem copy of the DB file (not open by any connection) on the same hardward/disks 2) using sqlite3[.exe]'s .dump piped into another sqlite3 instance to recreate the DB from DB at the destination 3) using sqlite3[.exe]'s .backup, which uses the Backup API you could use in your own code too (assuming available from Java). Now you'd have good reference point to compare against your own Java-based implementation. Completely guessing, but 370s seems to be "slow". Do #1 and/or #2 and/or #3 above, and you'll know for sure. FWIW, --DD PS: There are many ways to implement such a copy, and you're not saying how you implemented it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users