On Thu, Dec 17, 2009 at 11:20 AM, Robert Citek <robert.ci...@gmail.com> wrote:
> How can I speed up the sorting of a union all query?
BTW, here is a method for creating a sample dataset:
$ echo {1..1000}$'\t'{1..200}$'\t'1 |
tr ' ' '\n' |
sqlite3 -init <(echo '
create table foo (amp1 INTEGER, amp2 INTEGER, tag INTEGER) ;
.mod tabs
.imp "/dev/stdin" "foo"
') foo.db .quit
Regards,
- Robert
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
