On Saturday, 19 October, 2019 18:05, Peng Yu <pengyu...@gmail.com> wrote:
Looks like the difference between reading from disk and reading from cache. >I see that sqlite3 can be very different in terms of run time. >$ time sqlite3 file.sqa -Atv > /dev/null > >real 0m3.259s >user 0m0.193s >sys 0m0.704s >$ time sqlite3 file.sqa -Atv > /dev/null > >real 0m0.148s >user 0m0.086s >sys 0m0.057s > ># Then do some else briefly > >$ time sqlite3 file.sqa -Atv > /dev/null > >real 0m3.853s >user 0m0.200s >sys 0m0.828s > >$ time sqlite3 gncdhgncsym2htmlsqa.sqa -Atv > /dev/null > >real 0m0.172s >user 0m0.094s >sys 0m0.065s > >file.sqa is of size 4.1G and 42282 rows. > >Does anybody know why there can be such big differences in speed? > >My testing machine is a MacbookAir. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users