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