Not sure if it helps, but you could try
sqlite3 somedb '.import /dev/stdin hugetable' < huge.file
making OS handle file reading instead of another process (cat).
LS
2013/11/14 lpryszcz <l.p.prys...@gmail.com>
> Hi, Often I pipe tables (from .gz or multiple files). I found it also work
> for large files that otherwise fail with `Error: cannot open :huge.file"`:
>
> cat huge.file | sqlite3 somedb '.import /dev/stdin hugetable'
>
> But it could be slower that using `real` file import. Anyone have an idea?
>
> L.
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
