[Sqlrelay-discussion] 'Persistent' Connections to SQLRelay from PHP

[Welby M. <wel...@wh...>]

Hello

We are currently in the process of deploying SQLRelay across our
Authentication & Authorization estate and have unfortunately come into
a slight show stopper. Due to the way that our Auth tier is written we
deal with multiple small requests which is meaning a new connection
tear up and tear down for each request. As SQLRelay isn't running on
each of the web servers in the Auth Tier we've not been able to use
the local socket and have noticed that our average time for a standard
auth call (averaging at 5 requests) is taking upwards of 700mS. The
same using Oracle with a persistent DB connection is taking around 150
mS.
Obviously we're quite anxious of this and would like to know if there
are any plans to implement persistent connections in the SQLRelay PHP
extension or if it is possible to 'chain' SQLRelay servers to each
other (ie SQLRelay running on a web server connecting to our dedicated
SQLRelay hosts which in turn connect to Oracle?

Thanks
Welby