I know this doesn't really have anything to do with java but I really would appreciate help with this.
I'm planning a database which will at most have 1000 records with 20 fields, my estimations for its size are, well, tiny (i.e. few megabyte range at most).
Am I right? I've never had to estimate database size before... (small-time, I know...)
I have to make a request for application hosting and for something so small they are making me jump through too many hoops.
posted 11 years ago
Well, you could get more precise by calculating the max row size and then multiplying that by the estimated number of rows. For example, just to make things easy, let's say you have one table with 3 columns: 1. Integer (4-bytes) 2. varchar(6) (6-bytes) 3. varchar(10) (10-bytes) Total row size = 20b Total table size = 20b * 1000 rows = 20,000b = 19.5kb
Of course that's just data storage size.
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"