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 6 of 6
  1. #1
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts

    Question Database Storage Capacity

    I was wondering what is the Database Storage Capacity for the following databases:

    MySQL 5

    Microsoft Sql Server 2005

    MS Access 2003



    Thanx

  • #2
    Senior Coder angst's Avatar
    Join Date
    Apr 2004
    Location
    Toronto, Ontario
    Posts
    2,114
    Thanks
    15
    Thanked 122 Times in 122 Posts
    would depend on the storage capacity of the server.

  • #3
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts
    i m not talking about the capacity of the servers but the the capacity of those databases

  • #4
    Senior Coder angst's Avatar
    Join Date
    Apr 2004
    Location
    Toronto, Ontario
    Posts
    2,114
    Thanks
    15
    Thanked 122 Times in 122 Posts
    lol.. ya, i realize this.
    now pay close attention...

    MySQL 5 / Microsoft Sql Server 2005 - AS MUCH SPACE AS YOU HAVE AVAILABLE ON THE DRIVE IT'S DATA IS INSTALLED ON!


    MS Access 2003 - wouldn't recommend doing anything larger then 10-20 mb.

  • #5
    Regular Coder
    Join Date
    Jun 2006
    Location
    UK
    Posts
    922
    Thanks
    302
    Thanked 3 Times in 3 Posts
    ok but there is always a physical limit of everything...I want to know those limits for these databases

  • #6
    Senior Coder angst's Avatar
    Join Date
    Apr 2004
    Location
    Toronto, Ontario
    Posts
    2,114
    Thanks
    15
    Thanked 122 Times in 122 Posts
    http://dev.mysql.com/doc/refman/5.0/en/full-table.html < mysql

    "this limit can be changed up to the maximum allowable size of 65536TB", do u think you'll reach that?

    http://www.thescripts.com/forum/thread189353.html < ms Access - Unlimited, but not recommended over 2gig.

    no info found for limits on MS SQL, but I would asume it can do as much or more then the MySQL server at 65536TB.


  •  

    Posting Permissions

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