I had a big portal in Codeigniter in which user can register and they can comment on each products, they can create their profiles, a forum ( custom made ) connected to this etc...
Also the company's main products also stored in the same DB.
The requirements is since the products tables are mpre important than users, now its some difficult for back up and all, I mean we have to split the database into two. ie one for users and their activities and other for main products.
I am bit confused to connect 2 dbs in a single codeigniter because we have to call/fetch data from both db's in a view / model
Any ideas ?