Wow! Now takes about 5 seconds! Thanks! Luc -----Original Message----- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: November 4, 2004 3:46 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] transfer data from an MDB file to SQLite
Edovia Technologies said: > It works, although it takes quite a while to transfer data. Like about a > minute for 500 records! > > I'm sure there's a better way. Anyone knows? Wrap each table into a transaction. You'll be shocked at how much faster it is. I have a similar application to transfer a 2.5 MB paradox database. It took hours before I added the transaction, and minutes after. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development ---
