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
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
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
3 matches
Mail list logo