Reduce Number of Open Connections
Brought to you by:
keeleyd
Menu
▾
▴
I have a web site that receives a couple of million hits per day and each page has several queries on it. The site traffic load is growing 50% per year or so. Right now I peak at 140 or so open connections at a time. I would like to reduce the number of connections because of the system resources required for that number of connections. I am using php connection pooling which helps, however a connection is still opened for each apache process I have running. Will this connection pooling system allow me to re-use connections across apache processes? If so I think this could make a big difference - perhaps reduce the number of open connections by a factor of 10.
If I understand well what is your problem, I think you're right.
SQLB connection pool is completely independant of apache. You configure the number of connection you need and all the client programs will use them and no more.
SQLB is also able to adapt his number of connection in relation with the number of request received. You can configure the max and the minimum number of connection you want. This is what is called "load management" in the caracteristics of SQLB.
SQLB has improved on huge site and is very efficient particularly if you use Oracle database (factor of 10 more connection/sec)
hope it will help and feedback are welcome ;)
good luck !
GrumZ