Try to use transaction syntax. Rick
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of �L�~ Sent: Tuesday, May 11, 2010 1:48 PM To: sqlite-users@sqlite.org Subject: [sqlite] Insert large data question ?? 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
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
