I am using multiple databases using CodeIgniter Active Records class. I had to disable persistent connection with MySQL, because CodeIgniter Active Records class can't make persistent connections using multiple databases.

I am looking at the load of my database, it seems like it's using most of it's queries calling "change database" and I am not sure if that's a good sign.

How can I optimize this without having to call "change database" all the time?