Does the following document help?
http://www.sqlite.org/faq.html#q19
On Tue, May 11, 2010 at 1:47 AM, 風箏 <ler...@gmail.com> wrote:
> Dear
>
> I have about 9 million data insert string need to insert into an table
> ,each
> row data is unique
>
> this is a sample:
> insert into mydata
> VALUES(38824801,000000000000000056888,'AABBCC',4.9999999,157,'2009/9/10
> 19:55:50');
>
> this is my schema:
> table|mydata|mydata|2|CREATE TABLE mydata
> (
> itno VARCHAR(20),
> lcno VARCHAR(20),
> srno VARCHAR(10),
> ran VARCHAR(20),
> pp INTEGER,
> cdate VARCHAR(20),
> PRIMARY KEY (itno DESC, lcno ASC)
> )
> index|sqlite_autoindex_mydata_1|mydata|3|
> index|IDX_CDATE|mydata|4|CREATE INDEX IDX_CDATE on mydata (cdate DESC)
> index|IDX_PRICE|mydata|5|CREATE INDEX IDX_PRICE on mydata (pp ASC)
> index|IDX_RANK|mydata|6|CREATE INDEX IDX_RANK on mydata (ran DESC)
> index|IDX_LC_NO|mydata|7|CREATE INDEX IDX_LC_NO on mydata (lcno ASC)
> index|IDX_SR_NO|mydata|8|CREATE INDEX IDX_SR_NO on mydata (srno ASC)
>
> but i have question about performance,everytime doing the job takes about
> 63000 seconds
> is there any suggestion can make more faster with my job ??
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
---------------------
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
