Select Code to Download

INSERT INTO llil_result (name, count)
    SELECT name, sum(count) AS total FROM llil_raw GROUP BY name ORDER
+ BY total desc, name;

$ /usr/bin/postgres -D /var/lib/pgsql/data -h localhost

...
real    0m52.508s
user    0m0.001s
sys     0m0.001s

$ /usr/bin/postgres -D /tmp/data -h localhost

...
real    0m49.396s
user    0m0.001s
sys     0m0.002s

$ perl -I ~/perl5/lib/perl5/ llilsql.pl --threads=1 big{1,2,3}.txt | c
+ksum
Tie::Hash::DBD SQLite database - start
...
    count lines  : 10545600
    count unique : 10367603
2956888413 93308427