[client][managed][offline] improve performance of bulk insert and delete
[client][managed][offline] support for soft delete