On 9 Apr 2010, at 11:57am, Igor Tandetnik wrote:
> Christoph Walser, ETH Zurich wrote:
>> Is there a way to do all the 5000 rows in one transaction to minimize
>> database locking time? I know I can do a sqlite3_exec with "BEGIN
>> TRANSACTION", then do the inserts and then "COMMIT TRANSACTIONS"
Christoph Walser, ETH Zurich wrote:
> I have a C application which generates around 1000 rows of data per
> second to insert in an SQLite database.
> What I now do is to collect 5000 rows in a buffer and then for each row,
> execute sqlite3_bind_*, sqlite3_step, sqlite3_reset.
>
> I wonder now how
Hi everybody,
I have a C application which generates around 1000 rows of data per
second to insert in an SQLite database.
What I now do is to collect 5000 rows in a buffer and then for each row,
execute sqlite3_bind_*, sqlite3_step, sqlite3_reset.
I wonder now how sqlite does this internaly: with
3 matches
Mail list logo
