[sqlite] indexing large sqlite db

Hello, I am building a very large (> 500M rows, ~6 GB) sqlite database that has three integer columns. I find that inserting all the rows takes only a couple hours, but when I try to create an index on any of the columns the process will run for days without finishing. If the entire operation

RE: [sqlite] Seems like a bug in the parser

I find this feature useful, especially in queries which use aggregate functions, such as the following: SELECT sum(a) FROM tbl GROUP BY b The question should be what the compelling reason is to remove a useful feature. -Andrew McCollum -Original Message- From: Kurt Welgehausen