multiple database creation problem

[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....

[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

[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.

[eluser]CroNiX[/eluser]
This shouldn't be necessary with a normalized database that is properly indexed.