...

View Full Version : Database Storage Capacity



phantom007
01-30-2007, 07:54 AM
I was wondering what is the Database Storage Capacity for the following databases:

MySQL 5

Microsoft Sql Server 2005

MS Access 2003



Thanx

angst
01-30-2007, 04:53 PM
would depend on the storage capacity of the server.

phantom007
01-30-2007, 04:57 PM
i m not talking about the capacity of the servers but the the capacity of those databases

angst
01-30-2007, 05:03 PM
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.

phantom007
01-30-2007, 05:10 PM
ok but there is always a physical limit of everything...I want to know those limits for these databases

angst
01-30-2007, 05:16 PM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum