Bella Chan <[email protected]> wrote: > I am surprised to see that C is slower than Perl when inserting lots of data > into DB sequentially as I have 100 columns in a row > so I have been making 100 bind_int calls while Perl I only need to do execute > once.
You are doing something wrong. Are you re-preparing the statement for each row, by any chance? Are you grouping your inserts within a transaction? Show some code. > Trying to see if I can use bind_value() > instead but no clue ho to create the sqlite3_value structure. sqlite3_bind_value is only useful inside custom functions. In any case, your problem lies elsewhere. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
