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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
