top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

doubts about pool of connections with my application developed in PHP

+1 vote
417 views

I have some doubts about pool of connections with my application developed in PHP. I want optimize the use of resources and database connections has a high computational cost. So the idea is keep a pool of open connections with database.
I'm using Apache webserver, language PHP and PostgreSQL database. In this case the pool of conections must be configured on Apache, PHP or PostgreSQL?

posted Sep 2, 2013 by Amit Parthsarthi

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

That's what mod_dbd does for you.

But using a connection pool with PHP throws you straight into PHP-vs-threading issues. Is your application thread-safe?

answer Sep 2, 2013 by Satish Mishra
Similar Questions
+3 votes
Restrict incoming connections per Application Tomcat 6.0.37

I'm developing a permission system in Tomcat and I would like to restrict incoming connections per application. I mean, I want to restrict incoming connections in some applications and permit them in others.

I have tried to do it with the Security Manager (SocketPermission), but it doesn't restrict all incoming connections. And also I have tried with RemoteAddrValve and RemoteHostValve () but it restricts all connections, not only the incoming ones. I have been searching other way to do that but I couldn't find anything.

Is it possible? Could anybody help me?

+2 votes
Tomcat Connection Pool Alias

With Tomcat 7.0.40 version, we are using Tomcat DBCP for pooling connections.

We are able to pool connections for different aliases. But for one alias, connections are not pooling. The user and password is good because the same alias in apache dbcp works fine.

Why are we not able to pool any connections here?

+1 vote
What limits the amount of text displayed using print_r with PHP 5.4/Apache2.4

I've two machines set up with Apache2.4 and PHP5.4.15 and I'm trying to debug owncloud as it has problems with Apache2.4. This autoloader and routing 'fun' seems totally over the top, and is failing without giving any errors, but the question is "what limits the amount of text displayed using print_r() ?" Where I drop in a print statement causes crashes, but when working I'm not getting a complete printout. One machine is clipping at around 4500 characters, while the other is managing around 9000, and neither is displaying the 'TAG' labels after that block.

It's not something I've seen before ... I've been using this method for many years and normally see all the text. So can anybody throw light on why this may be happening now? Interestingly the two machines are giving different problems with this application which works correctly on Apache 2.2

+2 votes
We developed an AirWays web Application on Laravel PHP Framework.

We developed an AirWays web Application on Laravel PHP Framework.

Having daily active users 2000+ no's so we need to add few other features, and we dont want to stop the website on single day. We want a solution where can code independently on server and should be updated in real time. How?

Need Real time coding to be implemented onto the server?

+2 votes
Is it possible to use PHP 5.2.5 with Apache/2.4.6?

Is it possible to use PHP 5.2.5 with Apache/2.4.6?

I have an application that was written in WAMP5 using PHP 5.2.5, and I am trying to get the application onto a CentOS server and I can't get it to work with 5.4.16.

Are there any good tutorials on using an older version of PHP with Apache?

...