according to this post http://sqlite.phxsoftware.com/forums/t/134.aspx, i am inserting this way
Dim conn As SQLiteConnection = New SQLiteConnection("Data Source=" & dbPath)
'conn.SetPassword(dbPassword)
conn.Open()
Dim mytransaction As SQLiteTransaction = conn.BeginTransaction()
Dim cmd As SQLiteCommand = New SQLiteCommand(conn)
'// insert directory //
For i = 0 To UBound(oDir)
If oDir(i).Url IsNot Nothing AndAlso DirExist(oDir(i).Url) = False Then
cmd = New SQLiteCommand("INSERT INTO directory" & _
"([name],[category],[url],[type]) VALUES (@name,@category,@url,@type)", conn)
cmd.Parameters.AddWithValue("@name", oDir(i).Name.ToLower)
cmd.Parameters.AddWithValue("@category", oDir(i).Category.ToLower)
cmd.Parameters.AddWithValue("@type", oDir(i).Type.ToLower)
cmd.Parameters.AddWithValue("@url", oDir(i).Url.ToLower)
'Debug.Print(cmd.CommandText)
cmd.ExecuteNonQuery()
End If
Next
mytransaction.Commit()
but this taks some minutes for just 10,000 records, any help to make it faster?