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
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
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
3 matches
Mail list logo