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 ??
Is there any method to get data from the databases using XML