+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: multiple database creation problem (/showthread.php?tid=48820)
multiple database creation problem - El Forum - 01-30-2012
[eluser]Bigil Michael[/eluser]
I have a main database which contains information about more than thousand hotels. I have done advanced search, it is working fine. Inorder to increase the speed of advanced search i decided to generate sub databases. That means devide the main database into sub databases in accordance with city name. I think you understand what iam looking for
Can any one help me?....
any suggestions are accepted....
thanks in advance....
multiple database creation problem - El Forum - 01-30-2012
[eluser]smilie[/eluser]
What is your exact question now? You can do as you said, but I think that even 1 (large) database if properly optimized should not give you any performance problems...
Cheers,
Smilie
multiple database creation problem - El Forum - 01-30-2012
[eluser]Bigil Michael[/eluser]
thanks for your help....
now i generated subdomains like bangalore.mydomain.com
in this url it search only restaurant within the city bangalore.
thats why iam looking for subdatabases.
multiple database creation problem - El Forum - 01-30-2012
[eluser]CroNiX[/eluser]
This shouldn't be necessary with a normalized database that is properly indexed.