in reply to Re^7: Threads and DBD::SQLite?
in thread Threads and DBD::SQLite?
OK, so my numbers for "Read all 100000 records using 4 threads" were really
" Read ", $R * 100 / $N, " % of all records using 4 threads"
that means the test was doing 0.1 % of what the output-line was saying.
Here is a run without that mistake:
# The offending code line changed to: # $Q->nq( $_ ) for (shuffle 1 .. $N); SQLite - 5.90120077 s - Populate db with 100000 rows SQLite - 0.15266800 s - Create primary index SQLite - 0.53022408 s - Read all 100000 rows, unthreaded SQLite - 7.23427510 s - Read all 100000 rows, 4 threads Pg - 23.40106297 s - Populate db with 100000 rows Pg - 0.53076911 s - Create primary index Pg - 13.71553111 s - Read all 100000 rows, unthreaded Pg - 7.40499115 s - Read all 100000 rows, 4 threads
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^9: Threads and DBD::SQLite?
by BrowserUk (Patriarch) on Dec 17, 2013 at 08:54 UTC |