[odb-users] Does ODB support partial update? If not, how can we improve the performance?

[Albert Gu]

Get it. I will try it.

Thank you Boris!

-
Regards,
Albert

On 9/1/16, 11:39 PM, "Boris Kolpackov" <boris at codesynthesis.com> wrote:

>Hi Albert,
>
>Albert Gu <albert.gu at ringcentral.com> writes:
>
>> I am using ODB currently, just want to know how can I improve the
>> update/insert/delete performance?
>> 
>> Let's say, I have to insert 1000 new records, update 1000 old records,
>> delete 1000 records, after getting the response from server.
>> 
>> These records are mixed together. Is there any good performance practice
>> for this kind of issue?
>
>SQLite doesn't support batch operations (unlike say Oracle or SQL Server).
>
>First thing I would do is understand what is the time split between
>inserts, updates, and deletes. For updates, if only updating a few
>members, then object sections could help (Chapter 9; perhaps that's
>what you meant by "partial update").
>
>Also, with a lot of modification, suspending constraint checking
>always helps. If this is possible in your case, I would definitely
>try it first.
>
>Boris