SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    May 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Adding sorting and pagination to data from different DB

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

  2. #2
    Keeper of the SFL StarLion's Avatar
    Join Date
    Feb 2006
    Location
    Atlanta, GA, USA
    Posts
    3,747
    Mentioned
    65 Post(s)
    Tagged
    0 Thread(s)
    very difficult to do really...

    Is there a particular reason they're using multiple -servers-?

  3. #3
    SitePoint Member
    Join Date
    May 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation

    Quote Originally Posted by StarLion View Post
    very difficult to do really...

    Is there a particular reason they're using multiple -servers-?
    My requirement is to fetch data from 12 databases located in different servers.These 12 databases is used by other websites.A table is repeating in all these databases.i have to take all the data in those 12 tables and display it in a single list and add pagination and sorting to it.

  4. #4
    SitePoint Member
    Join Date
    May 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question

    Is there any method to get data from the databases using XML .


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •