Hi All,
I have created a sqlite database with "create table EMP (F1 INTEGER ,F2
TEXT(1120) primary key collate nocase,F3 INTEGER ,LMD TEXT(1120) ,F4
TEXT(1120) ,F5 TEXT(1120));".
Here F2(Field2) is primary key. I used transaction queries for every
25,000 records. But performance issue is there.
Is there anyway to optimize this?
Requirement: Insert 100,000,000 records.
Thanks and Regards,
Durga.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
