> -Original Message-
> From: Stephen Sutherland [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 10:33 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] How to Speed of Inserts
>
[snip]
>
>So it makes me a bit concerned that when I have to drop my
> XML repository
1. Use bind vars... prepare the statement once, execute it many times
binding values each time.
1a. Drop the index.
2. Use a transaction.
3. Commit every . In your case with only
10,000 recs, I would commit only at the very end.
4. Build the index at the end.
Really, 10k recs should insert in
Regarding:
"Is there away to maximize this speed dramatically ...?"
Yes, be sure to surround your inserts with a single transaction (i.e.,
"BEGIN", "END").
If you were doing millions of inserts, you might want to use a new
transaction after each, say, 5 thousand inserts.
If you don't
3 matches
Mail list logo
