...

View Full Version : Combine multiple database



maheshmnair
05-10-2011, 02:56 PM
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

Fumigator
05-10-2011, 04:12 PM
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.

maheshmnair
05-11-2011, 06:13 AM
How i take data from different databases simultaneously.

Fumigator
05-11-2011, 08:58 AM
Try selecting from each database individually and use PHP to combine the data.

maheshmnair
05-11-2011, 12:36 PM
but i want to apply pagination and sorting in that data's

Old Pedant
05-11-2011, 07:44 PM
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 ...

anuja
05-12-2011, 11:59 AM
check this link......
http://docs.joomla.org/How_to_connect_to_an_external_database



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum