Hi, Mahalakshmi, Regarding: "..Am I doing right or it's a lengthy process.If so suggest some other way for inserting the records?..."
I must confess I have not spent much time looking at the details of your email, but you will want to be sure to use a single transaction to insert many rows in your table if performance is an issue: http://www.sqlite.org/lang_transaction.html You'll likely want to use a transaction for at least 100 rows at a time -- or perhaps even for all 40000. After completing the insert, you may find you wish to use the CREATE INDEX command to speed up queries. This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the named recipient of this email please notify us immediately and do not copy it or use it for any purpose, nor disclose its contents to any other person. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
