How can i use connection pooling ? Should i use a software like PGPool ? Will the connection pooling boost considerably the performance ?
Leonel adviced me to use persistent connections ? hos do i use that ?
PS: I am using PHP for my applications.
Thanks
Najib
Talha Khan <[EMAIL PROTECTED]> wrote:
You should also consider using connection pooling inorder to attain better performance.RegardsTalha Khan
On 9/20/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:I have a web application that is accessed by a large number of users.
My application is written in PHP and uses postgres. Apache is our web server.
The performance of my application drops down when a large numbers of users connects at the same time. I need to have a better response time ! That's why i need to load balance the web requests and the database.
Regards,
Najib.
Ben Trewern <[EMAIL PROTECTED]> wrote:The solution you need all depends on the problem you are having. If you
explain how your application is written PHP, Java, etc and where your
performance problems are coming from, then someone could give you a better
answer!
Regards,
Ben"Najib Abi Fadel" wrote in message
news:[EMAIL PROTECTED]Robin Ericsson wrote:
On 9/18/06, Najib Abi Fadel wrote:
> Hi,
>
> i was searching for a load balancing solution for
> postgres, I found some ready to use software like
> PGCluster, Slony, pgpool and others.
>
> It would really be nice if someone knows which one is
> the best taking in consideration that i have an
> already running application that i need to load
> balance.
There isn't one tool that is the best, all three work very good based
on where they are used and what they are used for.
--
regards,
Robin
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Did you try them or have any experience with them. I need them for load
balancing my database and thus making the queries faster. I have a web
application heavely using a postgres database. Hundreds of users can connect
at the same time to my web application.
Thanks in advance for any help.
Najib.
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail.
