[Sqlrelay-discussion] 'Persistent' Connections to SQLRelay from PHP
Brought to you by:
mused
|
From: Welby M. <wel...@wh...> - 2009-05-28 16:49:45
|
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 |