Adding sorting and pagination to data from different DB

[anuja12]

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 ??

[adi123]

theres a tutorial on this link for what you are trying to do:

 

 

http://api.joomla.org/__filesource/fsource_Joomla-Framework_HTML_joomlahtmlpagination.php.html

 

 

 

[anuja12]

theres a tutorial on this link for what you are trying to do:

 

 

http://api.joomla.org/__filesource/fsource_Joomla-Framework_HTML_joomlahtmlpagination.php.html

 

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 .