[Sqlrelay-discussion] sqlrelay connection pooling and postgres
Brought to you by:
mused
|
From: blair b. <bla...@gm...> - 2006-11-22 05:40:19
|
Hi, I discovered SQLRelay a few weeks ago and thought it seemed like a good option for connection pooling a grid middleware application cluster that I am setting up. The app is written in python using postgres and will typically be running several instances for different users (separate databases) at once. When I was setting it up however I noticed this hidden deep in the config info: "When SQL Relay is used with any other database, it simply logs out and logs back in as a different user. This is quite inefficient and defeats the value of keeping persistent database connections." Does this mean that sqlrelay is actually of no use as a connection pool server to any DBMS other than oracle? If so, I think that needs to be made much clearer on the website. Or will it try and reuse connections to the same database when they are available and only reconnect when there are none available (in which case there is still some benefit, especially with a large pool)? Regards, -Blair -- In science one tries to tell people, in such a way as to be understood by everyone, something that no one ever knew before. But in poetry, it's the exact opposite. - Paul Dirac |