shadiadiph Posted June 13, 2010 Share Posted June 13, 2010 Just a couple of quick basic questions. 1 does a data base have a mximum size? 2 Do tables have a row limit or a limit on the number of rows that can be inserted? I ask the 2nd question like that because you need to have a auto primary number in a table Quote Link to comment https://forums.phpfreaks.com/topic/204636-question-about-maximum-database-and-table-sizes/ Share on other sites More sharing options...
ignace Posted June 13, 2010 Share Posted June 13, 2010 1 does a data base have a mximum size? Yes each data-type has a maximum size. Although some have an unreal large data-types (~64PB), in this case your HDD size will determine the actual maximum size of your database. 2 Do tables have a row limit or a limit on the number of rows that can be inserted? I am not certain if all DBMS have this option but I know MySQL has it MAX_ROWS = value as found on: http://dev.mysql.com/doc/refman/5.1/en/create-table.html Quote Link to comment https://forums.phpfreaks.com/topic/204636-question-about-maximum-database-and-table-sizes/#findComment-1071410 Share on other sites More sharing options...
shadiadiph Posted June 13, 2010 Author Share Posted June 13, 2010 So database size just over 250Tb yahoo and hotmail must have exceeded those limits I know most email sutems use txt files as emails but they have to be stored by a db somehow? How's about something like facebook or craigs list can't be a db per user I have been working on a project I am thinking ahead I want to have at least 100 million users I am just wondering how to divide it up??? Quote Link to comment https://forums.phpfreaks.com/topic/204636-question-about-maximum-database-and-table-sizes/#findComment-1071415 Share on other sites More sharing options...
James25 Posted June 14, 2010 Share Posted June 14, 2010 Database size is approximately 300. Quote Link to comment https://forums.phpfreaks.com/topic/204636-question-about-maximum-database-and-table-sizes/#findComment-1071729 Share on other sites More sharing options...
ignace Posted June 14, 2010 Share Posted June 14, 2010 Chances are services like Hotmail and Yahoo don't even use a traditional DBMS like MySQL and instead use something like NoSQL, like GMail which uses BigTable Quote Link to comment https://forums.phpfreaks.com/topic/204636-question-about-maximum-database-and-table-sizes/#findComment-1071744 Share on other sites More sharing options...
fenway Posted June 15, 2010 Share Posted June 15, 2010 So database size just over 250Tb yahoo and hotmail must have exceeded those limits I know most email sutems use txt files as emails but they have to be stored by a db somehow? How's about something like facebook or craigs list can't be a db per user I have been working on a project I am thinking ahead I want to have at least 100 million users I am just wondering how to divide it up??? This isn't your problem -- and never will be. Quote Link to comment https://forums.phpfreaks.com/topic/204636-question-about-maximum-database-and-table-sizes/#findComment-1072358 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.