On Sat, Oct 22, 2011 at 6:02 PM, Bo Peng <ben....@gmail.com> wrote: >> You may create multiple threads, but your hard drive only has one set of >> heads. > > I now realize this problem and is moving the data to a faster drive. > However, when copying the data out, the activity monitor reports > 40MB/sec read speed. I admit this is not a fast drive, but comparing > to the peak 700KB/sec read speed when three instances of sqlite3 were > running, there might still be room for improvement at the sqlite side.
It's not only speed in KB/sec that matters. It's also disk system usage as reported by iostat. If it's close to 100% then SQLite can't do any better. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users