View Full Version : Combine multiple database
05-10-2011, 03: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.
05-10-2011, 05: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, 07:13 AM
How i take data from different databases simultaneously.
05-11-2011, 09:58 AM
Try selecting from each database individually and use PHP to combine the data.
05-11-2011, 01:36 PM
but i want to apply pagination and sorting in that data's
05-11-2011, 08: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, 12:59 PM
check this link......
Powered by vBulletin® Version 4.2.2 Copyright © 2015 vBulletin Solutions, Inc. All rights reserved.