Possible duplicates: Connection pooling in PHP and php connection pooling mysql
I used to restore connections in $_SESSION.
but found it not good.
Asked
Active
Viewed 3,282 times
0
-
@ricebowl: His question is: 'How to implement database connection pool in PHP?' – Aug 30 '09 at 13:38
-
you need to implement apache module. – nam Oct 06 '12 at 08:09
-
look for swoole/openswoole and connection pooling – Dannyboy Jun 02 '22 at 12:14
2 Answers
3
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.
troelskn
- 115,121
- 27
- 131
- 155
-
this is not the case anymore. use swoole/openswoole to gain connection pool and many many other async enterprise features. – Dannyboy Jun 02 '22 at 12:14
-1
It is not minuscule, database connection is the most time consuming step while connecting to DB irrespective of the technology.
