[Sqlrelay-discussion] SQLRelay and PostgreSQL session...
Brought to you by:
mused
|
From: Cristian P. <cri...@cl...> - 2005-11-17 16:15:06
|
Hi, first at all I'm a new user of SQLRelay and I have a few questions: 1. Does SQLRelay keeps alive a PostgreSQL session? I say this cuz I have a very intensive web database application. I always use and do the same query in the database (just a call to a stored procedure as "select * from mysp()") This sp is written in plpgsql, and each time I have to execute it eats a lot of cpu. (mainly cuz I have to "recompile" the plpgsql, prepare the queries and so on). The first time I run it takes around 114ms, but the next time it would take just 15ms. I asked to the postgresql team and so on and I get the same answer, in a web application the performance could be so poor cuz there is no way to keep the same session alive for each web "consumer" process. I guess is so stupid, because I'm doing the same query everytime. 2. I've been using pgpool, and it doesn't help too much for me, certainly it keeps a set of connection alive, but it doesn't share the same session/connection between web consumers, so I just minimize the connection time, not the compile/prepare time of the plpgsql stored procedures. 3. I need to have 10M connections per day, is this possible with sqlrelay? Somebody has achieved similar performance? Thanks a lot for your answers, Thanks again. Cristian Prieto |