MySQL Database handling???

Discussion in 'MySQL' started by netpox, Apr 11, 2007.

  1. #1
    How much has a mysql database handle. Lets say you're running a database with 500,000 members. Will it be really slow? does it just depend on the server you have?
     
    netpox, Apr 11, 2007 IP
  2. Noodles25

    Noodles25 Active Member

    Messages:
    75
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #2
    Depends on what indexes you have on your database tables. If it has good indexes it can easily handle millions of records in each table
     
    Noodles25, Apr 11, 2007 IP
  3. Mystique

    Mystique Well-Known Member

    Messages:
    2,579
    Likes Received:
    94
    Best Answers:
    2
    Trophy Points:
    195
    #3
    Databases can handle large amount of information, is your hosting or server settings in combination with your software can make it slow or returning error connections :rolleyes:
     
    Mystique, Apr 11, 2007 IP
  4. mjesales

    mjesales Peon

    Messages:
    326
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I ran into an issue running the 500 meg 150k article dbase for articlesnatch - but i moved it to a clustered hosting environment... we are going to see how it goes...
     
    mjesales, Apr 12, 2007 IP
  5. ruby

    ruby Well-Known Member

    Messages:
    1,854
    Likes Received:
    40
    Best Answers:
    1
    Trophy Points:
    125
    #5
    Databases become slow mainly due to design. With the right amount of normalisation and indexing then you shouldnt have any problems. I have seen and have run MySQL databases myself with millions of records.

    Its all about design.
     
    ruby, Apr 14, 2007 IP
  6. weknowtheworld

    weknowtheworld Guest

    Messages:
    306
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Indexes means? Please tell thanks... :)
     
    weknowtheworld, Apr 14, 2007 IP
  7. ruby

    ruby Well-Known Member

    Messages:
    1,854
    Likes Received:
    40
    Best Answers:
    1
    Trophy Points:
    125