c++ - Efficient update of SQLite table with many records -

I'm trying to use sqlite (sqlite3) for a project to store hundreds of records (programs I do not need to run [my] SQL Server.)

I have to record several thousand records to enter the correct values ​​(they are hierarchical), but the standard

  update table set left_value = 4, right_value = 5 where id = 12340;  

Very slow I have tried around every thousand or around

  started; .... Update ... Update table set left_value = 4, right_value = 5 where id = 12340; Update .... Commit;  

But again, very slow. Strange, because when I put it in a few hundred thousand (with inserts), it ends in seconds.

I am currently trying to test the speed of the dragon (slow command line and python) before I move it to C ++ implementation, but it is still slow By speed and I am not doing anything wrong until I need to find a new solution. idea? (Also takes an Open Source option for SQLIT, which is also portable)

Table (ID ) Create table table id_index index

  on