Combine multiple database

I got a new task that to took data's from twelve different database and to display it together. Each of these database will get at least 20 new entries per day. I am working in Joomla, how do i do this and it wont make performance issue.
:confused:
Please help me.



Thank you

What part of your task are you stuck on? We can't sit here and write the whole thing for you. We need something specific to help out on.

How i take data from different databases simultaneously.

Try selecting from each database individually and use PHP to combine the data.

but i want to apply pagination and sorting in that data's

So you will have to do a 12-way UNION.


SELECT a, b, c FROM database1.table1 ...
UNION
SELECT x, y, z FROM database2.table2 ...
...
UNION
SELECT fee, fi, fo FROM database12.table12 ...

check this link......
http://docs.joomla.org/How_to_connect_to_an_external_database