1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql

Discussion in 'HTML, Graphics & Programming' started by Slime101, 8 Jun 2006.

  1. Slime101

    PermaBanned

    Joined: 18 Oct 2002

    Posts: 12,841

    Location: Lost!

    Can mysql handle multiple queries running on a multi-table 50,000 record database or will it all fall over due to the ammount of records?
     
  2. Noxis

    Banned

    Joined: 26 Jul 2003

    Posts: 6,348

    Location: Surrey

    It can handle it just fine.... depending on the hardware you slap it on of course. Mysql database are much much much bigger than that in the big corp world. Should see some of ours :o

    Would be much easier to admin them if it wasnt for them pesky users :mad:
     
  3. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,313

    Location: Plymouth

    50,000 is peanuts but it depends on the number of users, too :)
     
  4. Noxis

    Banned

    Joined: 26 Jul 2003

    Posts: 6,348

    Location: Surrey

    Indexing 4tw.
     
  5. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,313

    Location: Plymouth

    memcached for the ultimate win :D
     
  6. Slime101

    PermaBanned

    Joined: 18 Oct 2002

    Posts: 12,841

    Location: Lost!

    50,000 records, 50,000 potential users, but not all at the same time- pobably no more than several hundred at a time.

    I realise 50K is amll in DB terms, but big corps use MSSQL and alternatives usually over than mysql...or so i thought.
     
  7. Beansprout

    Man of Honour

    Joined: 31 Jan 2004

    Posts: 16,313

    Location: Plymouth

    That's a couple of orders of magnitude off big corp stuff, though :)

    MySQL is a very competent database. It's not what corporate stuff with complex requirements would run on - for that you have MSSQL, Oracle etc, since MySQL lacks lots of features of ""proper"" databases (well, v5 has taken some big steps from what I've read) - but for the majority of uses it's a very competent tool :)
     
  8. Adz

    Capodecina

    Joined: 18 Oct 2002

    Posts: 10,272

    Location: Berkshire

    Agreed. 50,000 records is nothing. I personally ran a 1,000,000 record table on a Dual Xeon 2.8 and I believe Berserker runs something even larger on lower spec hardware.

    Obviously if you're receiving masses of traffic and the database is poorly designed, performance will be poor but with a decent structure, decent hardware and well designed code, it should be a breeze :).
     
  9. Craig321

    Capodecina

    Joined: 2 May 2004

    Posts: 19,974

    http://game-monitor.com/

    Check out the number of database entries on that, and I'm sure other people have even more.

    92,000 not that many, but almost double 50,000 and it's handling perfectly :)
     
  10. Noxis

    Banned

    Joined: 26 Jul 2003

    Posts: 6,348

    Location: Surrey

    I think some of the biggest around use MySQL, I know that places such as lastminute.com where they have to store all those flight details do.