Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 7 of 7
  1. #1
    New to the CF scene
    Join Date
    May 2011
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Combine multiple database

    I got a new task that to took data's from twelve different database and to display it together. Each of these database will get at least 20 new entries per day. I am working in Joomla, how do i do this and it wont make performance issue.

    Please help me.



    Thank you

  • #2
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    What part of your task are you stuck on? We can't sit here and write the whole thing for you. We need something specific to help out on.

  • #3
    New to the CF scene
    Join Date
    May 2011
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    How i take data from different databases simultaneously.

  • #4
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    Try selecting from each database individually and use PHP to combine the data.

  • Users who have thanked Fumigator for this post:

    maheshmnair (05-11-2011)

  • #5
    New to the CF scene
    Join Date
    May 2011
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    but i want to apply pagination and sorting in that data's

  • #6
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,460
    Thanks
    76
    Thanked 4,373 Times in 4,338 Posts
    So you will have to do a 12-way UNION.

    Code:
    SELECT a, b, c FROM database1.table1 ...
    UNION
    SELECT x, y, z FROM database2.table2 ...
    ...
    UNION
    SELECT fee, fi, fo FROM database12.table12 ...
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #7
    New to the CF scene
    Join Date
    May 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts


  •  

    Posting Permissions

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