View Full Version : Combine multiple database

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.
Please help me.

Thank you

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.

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

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

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 ...
SELECT x, y, z FROM database2.table2 ...
SELECT fee, fi, fo FROM database12.table12 ...

05-12-2011, 11:59 AM
check this link......

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum