I'm going to develop an application that needs max performance. I will need:
- batch inserts of BLOB
- batch updates of BLOB
- batch select of BLOB
I consider to use OCCI but I'm not sure if it supports all optimizations that are done in OCI.
I want to minimize memory allocation, network round trips, etc.
Does OCCI support preparation of SQL statements, executing SQL without memory allocation, array's binding, so I can bind something like:
"SELECT data FROM data_table WHERE data_id IN :data_key FOR UPDATE" and use array binding for data_key?
Do these APIs have the same features in terms of operations I need? Is there any feature parity table for these APIs?