Hi there,
I need to migrate data from a different database into a SQLite database. What I've done is written a simple C++ app which opens both databases, does a select from one and an insert into the other. I'm wondering if there is a way to delay indexing on the insert. I'm going to be inserting between 1 and 4 million records in a couple of the tables. I want to just get the data into the table, and then let the database handle the indexes after all the inserts are done. The obvious solution is to drop the index, do the inserts, and the create the index, but I'm wondering if there's a different solution. Thanx! Mike ----- Michael D. Boucher Iron Mountain Digital 120 Turnpike Road Southborough, MA 01772 p: 508-808-7590 michael.bouc...@ironmountain.com <mailto:michael.bouc...@ironmountain.com> www.ironmountain.com/digital <http://www.ironmountain.com/digital> The information contained in this email message and its attachments is intended only for the private and confidential use of the recipient(s) named above, unless the sender expressly agrees otherwise. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws by means of email or in an attachment to email you must select a more secure alternate means of transmittal that supports your obligations to protect such personal data. If the reader of this message is not the intended recipient and/or you have received this email in error, you must take no action based on the information in this email and you are hereby notified that any dissemination, misuse, copying, or disclosure of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email and delete the original message. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
