SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: MySQL capacity.

  1. #1
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL capacity.

    hey people,

    I have a project in PHP and MySQL which requires quite a large number of tables, there are around 40 tables. Right now, I have them all in one database.

    However, I'm wondering whether that is too much for one database? Or should I split up some of my tables into another database? (My host does provide support for multiple MySQL databases)

    Thanks in advance.

  2. #2
    SitePoint Zealot
    Join Date
    Nov 2001
    Location
    Earth
    Posts
    103
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Howdy,

    40 tables really does not seem like that much.

    Backup and recovery could be an issue if you split up the tables into multiple databases. Unless you can assure that both databases are backed up at exactly the same time, they may get out of sync. if you ever have to restore one or the other.

    Frank
    http://www.serverexpert.com/ Discuss servers and the software that makes them work.
    http://www.webmasters-resources.com/ Resources for webmasters.


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
  •