Regarding: "Meanwhile I found an '.import' command on SQLite, but I can't find a suitable documentation on how it works."
It can be easy to miss page: http://www.sqlite.org/sqlite.html where this is documented. Basically, it sounds like you might want to invoke the command line utility, sqlite3, then : .separator ' ' .import myfile.txt mytable (Note that there must be no terminating semicolon on these dot commands) This assumes you have precisely ONE space between each and every value. With 16 million lines, you may have some subtler issues. You'll want to remove any indices and recreate them after the import, for example. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
