Possible duplicates: Connection pooling in PHP and php connection pooling mysql
I used to restore connections in $_SESSION.
but found it not good.
-
@ricebowl: His question is: 'How to implement database connection pool in PHP?'user142019– user1420192009-08-30 13:38:00 +00:00Commented Aug 30, 2009 at 13:38
-
you need to implement apache module.nam– nam2012-10-06 08:09:53 +00:00Commented Oct 6, 2012 at 8:09
-
look for swoole/openswoole and connection poolingDannyboy– Dannyboy2022-06-02 12:14:10 +00:00Commented Jun 2, 2022 at 12:14
Add a comment
|
2 Answers
It is impossible to implement a database pool in php, because each request runs in a completely new process. There is nothing that survives between requests. The library may have its own database pool (In the mysql api, it's called persistent connections). For mysql, it's moot point though, since the cost of establishing a new connection is minuscule.
1 Comment
Dannyboy
this is not the case anymore. use swoole/openswoole to gain connection pool and many many other async enterprise features.
It is not minuscule, database connection is the most time consuming step while connecting to DB irrespective of the technology.
Comments
