SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Aug 2002
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL efficiency...

    Hey...

    I was just wondering, in which situation would MySQL function more effeciently in these 2 examples:



    First Example
    ==========

    Database
    +table_users1
    +table_bleh1
    +table_example1
    +table_test1
    +table_etc1
    +table_users2
    +table_bleh2
    +table_example2
    +table_test2
    +table_etc2
    +table_users3
    +table_bleh3
    +table_example3
    +table_test3
    +table_etc3



    Second Example
    ========
    Database1
    +table_users
    +table_bleh
    +table_example
    +table_test
    +table_etc

    Database2
    +table_users
    +table_bleh
    +table_example
    +table_test
    +table_etc

    Database3
    +table_users
    +table_bleh
    +table_example
    +table_test
    +table_etc



    Basically splitting the tables down into different databases... I figured the second option would be more efficient, but then I also thought it may slow it down if it has to access lots databases at once and keep changing etc... thoughts please thanks in advance

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to a more appropriate forum

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  3. #3
    SitePoint Enthusiast
    Join Date
    Aug 2002
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Whoops

    Where did I post it?

  4. #4
    SitePoint Member Vexalith's Avatar
    Join Date
    Aug 2002
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you want to join the various tables together in any combination, then putting them all in one database is probably more efficient.

    If the three sets of tables are completely separate, it's probably best to put them in separate databases - I'm not sure how much faster this would be, but I think at least a little.

  5. #5
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Whoops

    Originally posted by HyperDawn
    Where did I post it?
    PHP

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


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
  •