[sqlite] How do I speed up CREATE INDEX ?

[Mohd Radzi Ibrahim]

Hi,
I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million 
rows (with no index). But then when I run CREATE INDEX it took me 40 mins to do 
that. What could I do to speed up the indexing process ?

Thanks.


Radzi.