search

K2InformaticsGmbH / erloci

Erlang Oracle native driver - DEPRECATED, see https://github.com/K2InformaticsGmbH/oranif instead
Apache License 2.0
37 stars 11 forks source link

OCI_SESSGET_SPOOL supportivity #2

Closed pradeeguru closed 10 years ago

pradeeguru commented 10 years ago

I'm looking for the pool facility provided in c-bik / erloci as {ok, Pool} = oci_session_pool:start_link("127.0.0.1", 1521, {service, "db.local"}, "dbauser", "supersecret",[]).

But I couldn't find it here. I can see OCISessionGet()'s mode is OCI_DEFAULT.

c-bik commented 10 years ago

This interface is deprecated and session pooling isn't supported at the moment. Pool support may be added in future through oci_port interface. Keeping it as open to work on it later

pradeeguru commented 10 years ago

Thanks for your reply. My application requires high transactions rate to db. I hope single session is not good for it. Till I get pool support from oci_port, I better start individual sessions(oci_port:get_session) and maintain them as a pool in ets and use . Is that right temporary approach as you think?

c-bik commented 10 years ago

I would suggest considering that your permanent design approach. At the cost of spawning a number of OS processes, you also get isolation of connections (failure in one port process won't effect others) and a pair of communication pipes per connection (port-gen_server pair) ensuring independent throughput

pradeeguru commented 10 years ago

Thanks for your support.