RSmith wrote
>>
>> The code schema is as follows:
>>
>> foreach table
>> {
>> BEGIN
>> INSERT INTO table VALUES(....)
>> INSERT INTO table VALUES(....)
>> ...
>> COMMIT
>> }
>>
>> Large column values are supplied as parameters, the rest (vast majority)
>> is
>> passed through SQL command.
>
> When you say "passed through SQL command", you mean using
> sqlite3_execute()?
>
> If so, why not bind them all? That will be significantly faster...
Not so in c# wrapper, where the overhead of binding is considerable.
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Huge-WAL-log-tp79991p80065.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
