On 2015/01/16 11:33, Jan Slodicka 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...
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
