01-15-2010, 02:23 AM
[eluser]Maglok[/eluser]
As a little sidenote: Profiler has issues with displaying the queries if it is run on PHP4.
As for 2 databases: There is a semi trick. Lets say you have two databases and one is used a lot more then the other, then define that one LAST in the database.php. If you then reference $this->db it will use that database. You would have to load the other database with something like: $this->db2 = $this->load('db2', TRUE); and reference it using $this->db2->something.
I found that I only had to change bits of code where I wanted to approach the 2nd database.
As a little sidenote: Profiler has issues with displaying the queries if it is run on PHP4.
As for 2 databases: There is a semi trick. Lets say you have two databases and one is used a lot more then the other, then define that one LAST in the database.php. If you then reference $this->db it will use that database. You would have to load the other database with something like: $this->db2 = $this->load('db2', TRUE); and reference it using $this->db2->something.
I found that I only had to change bits of code where I wanted to approach the 2nd database.
