Re: [sqlite] migrating a pipeline to using sqlite

2009-07-19 Thread Robert Citek
On Tue, Jul 7, 2009 at 10:20 AM, Michal Seliga wrote: > Robert Citek wrote: >> create table foo ( >> col_1, col_2, col_3, col_4, col_5, col_6, col_7, col_8, col_9, >> col_10, col_11, col_12, col_13, col_14, col_15, col_16, col_17, >> col_18, col_19, col_20, col_21, col_22 ) ; >> .mode tab >> .im

Re: [sqlite] migrating a pipeline to using sqlite

2009-07-07 Thread Michal Seliga
Robert Citek wrote: > create table foo ( > col_1, col_2, col_3, col_4, col_5, col_6, col_7, col_8, col_9, > col_10, col_11, col_12, col_13, col_14, col_15, col_16, col_17, > col_18, col_19, col_20, col_21, col_22 ) ; > .mode tab > .imp "foo.tsv" "foo" > select col_9, col_22, count(*) as "coun

[sqlite] migrating a pipeline to using sqlite

2009-07-07 Thread Robert Citek
I have a command pipeline that I would like to transfer to sqlite. However, the performance under sqlite is significantly slower, which makes me think that I am doing something not quite correctly. How can I improve the performance of this task using sqlite? foo.tsv is a tab-delimited file with 2