Mysql database Connection pooling with CI?

[eluser]esra[/eluser]
You need to spend some time reading the database library portion of the user guide. Read "Connecting to Multiple Databases" on this page.

http://ellislab.com/codeigniter/user-gui...cting.html

CI connections are assigned a name or DSN. Thus, you can reuse the same connections over and over again by referencing the existing named connections. You can do the same in Java, ASP and other programming environments. The trick is to use a get method that returns a reference to your pooled database objects (connections) which are available globally to your entire application. To do what you want, you only need to create a small number of database objects for the pool and reuse them as needed. If work leaves me alone, I will try to play with this over the weekend.