Clemens Ladisch <clem...@ladisch.de> writes: > Sarge Borsch wrote: >> time xzdec something.sql.xz | sqlite3 something.db > > This measures only xzdec; it does not catch anything that sqlite3 does > after xzdec has finished and closed the pipe.
Nitpick: In bash or zsh, `time` is handled by shell, and measures both sides of pipe (in dash it is not, but dash is not intended for interactive use). >> IMO sqlite needs some optimisation for this case when there’s a huge >> INSERT statement, because the speed difference is enormous. > > The huge statement must be completely parsed, and compiled into a huge > VDBE program. I don't see how SQLite could do anything different. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
