[odb-users] Re: lazy pointers not working and update performance issue

[Andrew Cunningham]

>
> SQLite doesn't support bulk operations (unlike, say, SQL Server and
>> Oracle). A few things you can try, however:
>>
>> 1. Split the update into several smaller transaction, say 100 objects
>> at a time. Chances are it takes so long because SQLite has to maintain
>> a fairly large log.
>>
>> 2. Consider using object sections (Chapter 9, "Sections") to update
>> only the few members that you have modified.
>>
>

I am using SQLIte and updating/persisting hundreds of  thousands of objects
in a few seconds. And this is all in one gigantic transaction and with a
hideously complex object model/schema. ODB itself is *never *the
bottleneck.
You need to profile your code to see where it is spending it's time.