Nope, that's the solution. :)
On Fri, Feb 20, 2009 at 11:56 AM, Boucher, Michael <michael.bouc...@ironmountain.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
