RE: [sqlite] transfer data from an MDB file to SQLite

2004-11-04 Thread Edovia Technologies
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 ta

Re: [sqlite] transfer data from an MDB file to SQLite

2004-11-04 Thread Clay Dowling
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 transf

[sqlite] transfer data from an MDB file to SQLite

2004-11-04 Thread Edovia Technologies
Hi! So far, what I do is that I go through each record of a table in a MDB file and use sqlite3_exec( m_pDB, "INSERT INTO...", 0, 0, &szError ); to transfer each record to my SQLite db. It works, although it takes quite a while to transfer data. Like about a minute for 500 records! I'm s