Re: [sqlite] Speeding up index insertion

RAM drive or SSD can help you... -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Speeding up index insertion

It was as simple as PRAGMA cache_size = 10; I want one *million* database disk pages. Thx, Doug On Tue, Apr 26, 2011 at 2:44 PM, Douglas Eck wrote: > Hi all, > I have a table like this; > CREATE TABLE entity ( >        id BIGINT NOT NULL, >        a_id VARCHAR(64), >    

Re: [sqlite] Speeding up index insertion

On Apr 26, 2011, at 11:44 PM, Douglas Eck wrote: > 3.1M records. > > When I create an index for a_id it is very slow to create (many hours). Hmmm... sounds like many hours too many :) For example, as a comparison point, on a underpowered laptop, indexing a randomly sorted text column over

[sqlite] Speeding up index insertion

Hi all, I have a table like this; CREATE TABLE entity ( id BIGINT NOT NULL, a_id VARCHAR(64), b_id VARCHAR(64), path VARCHAR, < more fields>, created_at TIMESTAMP, PRIMARY KEY (id) ); 3.1M records. When I create an index for a_id it is