View Full Version : Adding sorting and pagination to data from different DB

05-12-2011, 01:07 PM
My task is to take data from different databases and to display them in a single web page.I am working in joomla and i am able to take data from the databases using separate queries for each database.But the problem is that i need to give sorting and pagination to this web page. how can i do this without making any performance issue since all the databases contains a lot of data.
Or can i use a single sql query for this ??

05-17-2011, 12:06 PM
Is there any method to get data from the databases using XML .