• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Liutauras Vilda
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Scott Selikoff
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
  • Frits Walraven
Bartenders:
  • Stephan van Hulst
  • Carey Brown

Database Size

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 331
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Aaaaaand ... we're on the march. Stylin. Get with it tiny ad.
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic