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

[Boris Kolpackov]

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