anuja12

But here i am using 12 sql queries.I cant apply pagination and sorting to these queries directly.i need to apply them to the list made using the data from all those databases. And is there any method to get data from the databases using XML .

My task is to take data from different databases in different server 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 ??