Page 1 of 1

Search Through Database

Posted: Tue Dec 31, 2013 12:37 am
by meenu
Hi,

Scenerio:
I am creating an application in which I need to create many databases(let say db1,db2,db3...) with same tables(register1) with different data in all tables.
I want to search data from all the databases at once with single query.

My question: Is it effective to search through the databases. I mean how reliable it is? Will it affect the site's performance?

Re: Search Through Database

Posted: Tue Dec 31, 2013 2:17 am
by requinix
No, it is not effective.

Why do you need so many databases containing identical structures?