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. > 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. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
