Programming Help

Web Development

Welcome to Dream.In.Code
	Getting Help is Easy! Join 109,554 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,325 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now! Chat LIVE With a Expert Register to Make This Box Go Away!

porcupine75	26 Jul, 2008 - 05:43 PM Post #1
New D.I.C Head Joined: 3 Sep, 2007 Posts: 7 My Contributions	Hello Guys! I have done not this thing before but I think this would be useful for feasibility studies. Dependent or not on database software, how can one calculate (for tell) a disk space required for a certain/huge amount of records for one's database. Here's a sample single table design: Transactions Table TransactionCounter AutoIncrement Long TransactionId Number Long TransactionDate Date/Time StockCode Number Long Quantity Number Short Sub-Total Number Short Remarks String * 30 Posted Boolean Thanks! This post has been edited by porcupine75: 26 Jul, 2008 - 05:45 PM
	This Post Was Helpful! ^New!

Martyr2	26 Jul, 2008 - 05:54 PM Post #2
Programming Theoretician Joined: 18 Apr, 2007 Posts: 4,365 Thanked 83 times Expert In: C/C++, Java, VB, VB.NET, C#, PHP, Web Development, HTML & CSS, Javascript My Contributions	Well your estimation is going to greatly depend on the database type you use. Just because databases store data differently and some are more sloppy than others. However one great article you can check out refers to how you can estimate the size of a database based on its tables, clustered/non clustered indexes, and heap. Estimating the Size of a Database - SQL Server - MSDN The factors can be applied to many other databases. By knowing the size of indexes, calculating the overall storage size of tables based on the length of fields * number of rows, and calculating the heap you can get a good approximation. That would be a great place to start the search.
	This Post Was Helpful! ^New!